1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
%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
|
