%global _empty_manifest_terminate_build 0 Name: python-xlrd2 Version: 1.3.4 Release: 1 Summary: Library for developers to extract data from Microsoft Excel legacy spreadsheet files (xls) License: Apache License 2.0 URL: https://pypi.org/project/xlrd2/ Source0: https://mirrors.nju.edu.cn/pypi/web/packages/1c/c6/2288bc5ff119d35ee4e0acaa86cec5502286c7ec05a203d90b2fd72b45f1/xlrd2-1.3.4.tar.gz BuildArch: noarch %description ### xlrd2 xlrd2 is an effort to extend [xlrd project](https://github.com/python-excel/xlrd), which is no longer mintained by its developers. The main goal is to make it suitable for extracting necessary information from malicious xls documents. **Xlrd Purpose**: Provide a library for developers to use to extract data from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool. **Versions of Python supported**: 2.7, 3.4+. **Installation:** 1. Installing using pip pip install xlrd2 2. Installing the latest development Using pip pip install -U https://github.com/DissectMalware/xlrd2/archive/master.zip Or download the latest version wget https://github.com/DissectMalware/xlrd2/archive/master.zip Extract the zip file and go to the extracted directory python setup.py install --user **Quick start**: ```python import xlrd2 book = xlrd2.open_workbook("myfile.xls") print("The number of worksheets is {0}".format(book.nsheets)) print("Worksheet name(s): {0}".format(book.sheet_names())) sh = book.sheet_by_index(0) print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols)) print("Cell D30 is {0}".format(sh.cell_value(rowx=29, colx=3))) for rx in range(sh.nrows): print(sh.row(rx)) ``` **Another quick start**: This will show the first, second and last rows of each sheet in each file: python PYDIR/scripts/runxlrd2.py 3rows *blah*.xls **Xlrd Acknowledgements**: * This package started life as a translation from C into Python of parts of a utility called "xlreader" developed by David Giffin. "This product includes software developed by David Giffin ." * OpenOffice.org has truly excellent documentation of the Microsoft Excel file formats and Compound Document file format, authored by Daniel Rentz. See http://sc.openoffice.org * U+5F20 U+654F: over a decade of inspiration, support, and interesting decoding opportunities. * Ksenia Marasanova: sample Macintosh and non-Latin1 files, alpha testing * Backporting to Python 2.1 was partially funded by Journyx - provider of timesheet and project accounting solutions (http://journyx.com/). * Provision of formatting information in version 0.6.1 was funded by Simplistix Ltd (http://www.simplistix.co.uk/) %package -n python3-xlrd2 Summary: Library for developers to extract data from Microsoft Excel legacy spreadsheet files (xls) Provides: python-xlrd2 BuildRequires: python3-devel BuildRequires: python3-setuptools BuildRequires: python3-pip %description -n python3-xlrd2 ### xlrd2 xlrd2 is an effort to extend [xlrd project](https://github.com/python-excel/xlrd), which is no longer mintained by its developers. The main goal is to make it suitable for extracting necessary information from malicious xls documents. **Xlrd Purpose**: Provide a library for developers to use to extract data from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool. **Versions of Python supported**: 2.7, 3.4+. **Installation:** 1. Installing using pip pip install xlrd2 2. Installing the latest development Using pip pip install -U https://github.com/DissectMalware/xlrd2/archive/master.zip Or download the latest version wget https://github.com/DissectMalware/xlrd2/archive/master.zip Extract the zip file and go to the extracted directory python setup.py install --user **Quick start**: ```python import xlrd2 book = xlrd2.open_workbook("myfile.xls") print("The number of worksheets is {0}".format(book.nsheets)) print("Worksheet name(s): {0}".format(book.sheet_names())) sh = book.sheet_by_index(0) print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols)) print("Cell D30 is {0}".format(sh.cell_value(rowx=29, colx=3))) for rx in range(sh.nrows): print(sh.row(rx)) ``` **Another quick start**: This will show the first, second and last rows of each sheet in each file: python PYDIR/scripts/runxlrd2.py 3rows *blah*.xls **Xlrd Acknowledgements**: * This package started life as a translation from C into Python of parts of a utility called "xlreader" developed by David Giffin. "This product includes software developed by David Giffin ." * OpenOffice.org has truly excellent documentation of the Microsoft Excel file formats and Compound Document file format, authored by Daniel Rentz. See http://sc.openoffice.org * U+5F20 U+654F: over a decade of inspiration, support, and interesting decoding opportunities. * Ksenia Marasanova: sample Macintosh and non-Latin1 files, alpha testing * Backporting to Python 2.1 was partially funded by Journyx - provider of timesheet and project accounting solutions (http://journyx.com/). * Provision of formatting information in version 0.6.1 was funded by Simplistix Ltd (http://www.simplistix.co.uk/) %package help Summary: Development documents and examples for xlrd2 Provides: python3-xlrd2-doc %description help ### xlrd2 xlrd2 is an effort to extend [xlrd project](https://github.com/python-excel/xlrd), which is no longer mintained by its developers. The main goal is to make it suitable for extracting necessary information from malicious xls documents. **Xlrd Purpose**: Provide a library for developers to use to extract data from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool. **Versions of Python supported**: 2.7, 3.4+. **Installation:** 1. Installing using pip pip install xlrd2 2. Installing the latest development Using pip pip install -U https://github.com/DissectMalware/xlrd2/archive/master.zip Or download the latest version wget https://github.com/DissectMalware/xlrd2/archive/master.zip Extract the zip file and go to the extracted directory python setup.py install --user **Quick start**: ```python import xlrd2 book = xlrd2.open_workbook("myfile.xls") print("The number of worksheets is {0}".format(book.nsheets)) print("Worksheet name(s): {0}".format(book.sheet_names())) sh = book.sheet_by_index(0) print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols)) print("Cell D30 is {0}".format(sh.cell_value(rowx=29, colx=3))) for rx in range(sh.nrows): print(sh.row(rx)) ``` **Another quick start**: This will show the first, second and last rows of each sheet in each file: python PYDIR/scripts/runxlrd2.py 3rows *blah*.xls **Xlrd Acknowledgements**: * This package started life as a translation from C into Python of parts of a utility called "xlreader" developed by David Giffin. "This product includes software developed by David Giffin ." * OpenOffice.org has truly excellent documentation of the Microsoft Excel file formats and Compound Document file format, authored by Daniel Rentz. See http://sc.openoffice.org * U+5F20 U+654F: over a decade of inspiration, support, and interesting decoding opportunities. * Ksenia Marasanova: sample Macintosh and non-Latin1 files, alpha testing * Backporting to Python 2.1 was partially funded by Journyx - provider of timesheet and project accounting solutions (http://journyx.com/). * Provision of formatting information in version 0.6.1 was funded by Simplistix Ltd (http://www.simplistix.co.uk/) %prep %autosetup -n xlrd2-1.3.4 %build %py3_build %install %py3_install install -d -m755 %{buildroot}/%{_pkgdocdir} if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi pushd %{buildroot} if [ -d usr/lib ]; then find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst fi if [ -d usr/lib64 ]; then find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst fi if [ -d usr/bin ]; then find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst fi if [ -d usr/sbin ]; then find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst fi touch doclist.lst if [ -d usr/share/man ]; then find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst fi popd mv %{buildroot}/filelist.lst . mv %{buildroot}/doclist.lst . %files -n python3-xlrd2 -f filelist.lst %dir %{python3_sitelib}/* %files help -f doclist.lst %{_docdir}/* %changelog * Fri May 05 2023 Python_Bot - 1.3.4-1 - Package Spec generated