%global _empty_manifest_terminate_build 0
Name:		python-pylightxl
Version:	1.61
Release:	1
Summary:	A light weight excel read/writer for python27 and python3 with no dependencies
License:	MIT
URL:		https://github.com/PydPiper/pylightxl
Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/ad/fa/7b139a186f0623d8980d4f6acabd51c824c42394a7ee8e69dc0819632740/pylightxl-1.61.tar.gz
BuildArch:	noarch


%description
#### **High-Level Feature Summary**
- **Reader**
    - supports Microsoft Excel 2004+ files (``.xlsx``, ``.xlsm``) and ``.csv`` files
    - read files via str path, pathlib path or file objects
    - read all or selective sheets
    - read type converted cell value (string, int, float), formula, comments, and named ranges
- **Database**
    - call cell value by row/col ID, excel address, or range
    - call an entire row/col or a semi-structured table based on user-defined headers
- **Writer**
    - write to new excel file (write excel files without having excel on your machine)
    - write to existing excel files (see limitations below)
#### **Limitations**
Although every effort was made to support a variety of users, the following limitations should be read carefully:
- Does not support ``.xls`` files (Microsoft Excel 2003 and older files)
- Writer does not support anything other than cell data (no graphs, images, macros, formatting)
- Does not support worksheet cell data more than 536,870,912 cells (32-bit list limitation), please use 64-bit if

%package -n python3-pylightxl
Summary:	A light weight excel read/writer for python27 and python3 with no dependencies
Provides:	python-pylightxl
BuildRequires:	python3-devel
BuildRequires:	python3-setuptools
BuildRequires:	python3-pip
%description -n python3-pylightxl
#### **High-Level Feature Summary**
- **Reader**
    - supports Microsoft Excel 2004+ files (``.xlsx``, ``.xlsm``) and ``.csv`` files
    - read files via str path, pathlib path or file objects
    - read all or selective sheets
    - read type converted cell value (string, int, float), formula, comments, and named ranges
- **Database**
    - call cell value by row/col ID, excel address, or range
    - call an entire row/col or a semi-structured table based on user-defined headers
- **Writer**
    - write to new excel file (write excel files without having excel on your machine)
    - write to existing excel files (see limitations below)
#### **Limitations**
Although every effort was made to support a variety of users, the following limitations should be read carefully:
- Does not support ``.xls`` files (Microsoft Excel 2003 and older files)
- Writer does not support anything other than cell data (no graphs, images, macros, formatting)
- Does not support worksheet cell data more than 536,870,912 cells (32-bit list limitation), please use 64-bit if

%package help
Summary:	Development documents and examples for pylightxl
Provides:	python3-pylightxl-doc
%description help
#### **High-Level Feature Summary**
- **Reader**
    - supports Microsoft Excel 2004+ files (``.xlsx``, ``.xlsm``) and ``.csv`` files
    - read files via str path, pathlib path or file objects
    - read all or selective sheets
    - read type converted cell value (string, int, float), formula, comments, and named ranges
- **Database**
    - call cell value by row/col ID, excel address, or range
    - call an entire row/col or a semi-structured table based on user-defined headers
- **Writer**
    - write to new excel file (write excel files without having excel on your machine)
    - write to existing excel files (see limitations below)
#### **Limitations**
Although every effort was made to support a variety of users, the following limitations should be read carefully:
- Does not support ``.xls`` files (Microsoft Excel 2003 and older files)
- Writer does not support anything other than cell data (no graphs, images, macros, formatting)
- Does not support worksheet cell data more than 536,870,912 cells (32-bit list limitation), please use 64-bit if

%prep
%autosetup -n pylightxl-1.61

%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-pylightxl -f filelist.lst
%dir %{python3_sitelib}/*

%files help -f doclist.lst
%{_docdir}/*

%changelog
* Tue Apr 11 2023 Python_Bot <Python_Bot@openeuler.org> - 1.61-1
- Package Spec generated