diff options
| -rw-r--r-- | .gitignore | 1 | ||||
| -rw-r--r-- | python-xlrd2.spec | 246 | ||||
| -rw-r--r-- | sources | 1 |
3 files changed, 248 insertions, 0 deletions
@@ -0,0 +1 @@ +/xlrd2-1.3.4.tar.gz diff --git a/python-xlrd2.spec b/python-xlrd2.spec new file mode 100644 index 0000000..c42857c --- /dev/null +++ b/python-xlrd2.spec @@ -0,0 +1,246 @@ +%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 <david@giffin.org>." +* 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 <david@giffin.org>." +* 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 <david@giffin.org>." +* 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 <Python_Bot@openeuler.org> - 1.3.4-1 +- Package Spec generated @@ -0,0 +1 @@ +3bb8a5615cd38befc2e77dc7755fd16a xlrd2-1.3.4.tar.gz |