summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCoprDistGit <infra@openeuler.org>2023-04-10 07:58:01 +0000
committerCoprDistGit <infra@openeuler.org>2023-04-10 07:58:01 +0000
commit2341cd6ec1dd17b649a3ca6fae6927db8f881520 (patch)
tree4a1c9463372d085053894edb4b60d3e93766d90a
parent8f7d0d6d443200e569e7122e96084e603548bda0 (diff)
automatic import of python-xlrd
-rw-r--r--.gitignore1
-rw-r--r--python-xlrd.spec149
-rw-r--r--sources1
3 files changed, 151 insertions, 0 deletions
diff --git a/.gitignore b/.gitignore
index e69de29..92cff4c 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/xlrd-2.0.1.tar.gz
diff --git a/python-xlrd.spec b/python-xlrd.spec
new file mode 100644
index 0000000..32a3268
--- /dev/null
+++ b/python-xlrd.spec
@@ -0,0 +1,149 @@
+%global _empty_manifest_terminate_build 0
+Name: python-xlrd
+Version: 2.0.1
+Release: 1
+Summary: Library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files
+License: BSD
+URL: http://www.python-excel.org/
+Source0: https://mirrors.nju.edu.cn/pypi/web/packages/a6/b3/19a2540d21dea5f908304375bd43f5ed7a4c28a370dc9122c565423e6b44/xlrd-2.0.1.tar.gz
+BuildArch: noarch
+
+Requires: python3-wheel
+Requires: python3-twine
+Requires: python3-sphinx
+Requires: python3-pytest
+Requires: python3-pytest-cov
+
+%description
+|Build Status|_ |Coverage Status|_ |Documentation|_ |PyPI version|_
+xlrd is a library for reading data and formatting information from Excel
+files in the historical ``.xls`` format.
+ This library will no longer read anything other than ``.xls`` files. For
+ alternatives that read newer file formats, please see http://www.python-excel.org/.
+The following are also not supported but will safely and reliably be ignored:
+* Charts, Macros, Pictures, any other embedded object, **including** embedded worksheets.
+* VBA modules
+* Formulas, but results of formula calculations are extracted.
+* Comments
+* Hyperlinks
+* Autofilters, advanced filters, pivot tables, conditional formatting, data validation
+Password-protected files are not supported and cannot be read by this library.
+Quick start:
+ import xlrd
+ book = xlrd.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))
+From the command line, this will show the first, second and last rows of each sheet in each file:
+ python PYDIR/scripts/runxlrd.py 3rows *blah*.xls
+
+%package -n python3-xlrd
+Summary: Library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files
+Provides: python-xlrd
+BuildRequires: python3-devel
+BuildRequires: python3-setuptools
+BuildRequires: python3-pip
+%description -n python3-xlrd
+|Build Status|_ |Coverage Status|_ |Documentation|_ |PyPI version|_
+xlrd is a library for reading data and formatting information from Excel
+files in the historical ``.xls`` format.
+ This library will no longer read anything other than ``.xls`` files. For
+ alternatives that read newer file formats, please see http://www.python-excel.org/.
+The following are also not supported but will safely and reliably be ignored:
+* Charts, Macros, Pictures, any other embedded object, **including** embedded worksheets.
+* VBA modules
+* Formulas, but results of formula calculations are extracted.
+* Comments
+* Hyperlinks
+* Autofilters, advanced filters, pivot tables, conditional formatting, data validation
+Password-protected files are not supported and cannot be read by this library.
+Quick start:
+ import xlrd
+ book = xlrd.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))
+From the command line, this will show the first, second and last rows of each sheet in each file:
+ python PYDIR/scripts/runxlrd.py 3rows *blah*.xls
+
+%package help
+Summary: Development documents and examples for xlrd
+Provides: python3-xlrd-doc
+%description help
+|Build Status|_ |Coverage Status|_ |Documentation|_ |PyPI version|_
+xlrd is a library for reading data and formatting information from Excel
+files in the historical ``.xls`` format.
+ This library will no longer read anything other than ``.xls`` files. For
+ alternatives that read newer file formats, please see http://www.python-excel.org/.
+The following are also not supported but will safely and reliably be ignored:
+* Charts, Macros, Pictures, any other embedded object, **including** embedded worksheets.
+* VBA modules
+* Formulas, but results of formula calculations are extracted.
+* Comments
+* Hyperlinks
+* Autofilters, advanced filters, pivot tables, conditional formatting, data validation
+Password-protected files are not supported and cannot be read by this library.
+Quick start:
+ import xlrd
+ book = xlrd.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))
+From the command line, this will show the first, second and last rows of each sheet in each file:
+ python PYDIR/scripts/runxlrd.py 3rows *blah*.xls
+
+%prep
+%autosetup -n xlrd-2.0.1
+
+%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-xlrd -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Mon Apr 10 2023 Python_Bot <Python_Bot@openeuler.org> - 2.0.1-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..19fde94
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+ae3f951c857a490d432f0a7d722352bf xlrd-2.0.1.tar.gz