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
121
122
123
124
125
126
127
|
%global _empty_manifest_terminate_build 0
Name: python-gsheets
Version: 0.6.1
Release: 1
Summary: Pythonic wrapper for the Google Sheets API
License: MIT
URL: https://github.com/xflr6/gsheets
Source0: https://mirrors.nju.edu.cn/pypi/web/packages/75/81/4113175b8a0157301e5f4f4692c47db9fb35f78f5a27747f8c1367e67929/gsheets-0.6.1.zip
BuildArch: noarch
Requires: python3-google-api-python-client
Requires: python3-oauth2client
Requires: python3-tox
Requires: python3-flake8
Requires: python3-pep8-naming
Requires: python3-wheel
Requires: python3-twine
Requires: python3-sphinx
Requires: python3-sphinx-rtd-theme
Requires: python3-mock
Requires: python3-pytest
Requires: python3-pytest-mock
Requires: python3-pytest-cov
%description
|PyPI version| |License| |Supported Python| |Wheel|
|Build| |Codecov| |Readthedocs-stable| |Readthedocs-latest|
``gsheets`` is a small wrapper around the `Google Sheets API`_ (v4) to provide
more convenient access to `Google Sheets`_ from Python scripts.
`Turn on the API`_, download an OAuth client ID as JSON file, and create a
``Sheets`` object from it. Use its index access (``__getitem__``) to retrieve
SpreadSheet objects by their id, or use ``.get()`` with a sheet URL.
Iterate over the ``Sheets`` object for all spreadsheets, or fetch spreadsheets
by title with the ``.find()`` and ``.findall()`` methods.
SpreadSheet objects are collections of WorkSheets, which provide access to the
cell values via spreadsheet coordinates/slices (e.g. ``ws['A1']``) and
zero-based cell position (e.g. ``ws.at(0, 1)``).
Save WorkSheets (or all from a SpreadSheet) as CSV files with the
``.to_csv()``-method. Create ``pandas.DataFrames`` from worksheet with the
``.to_frame()``-method.
%package -n python3-gsheets
Summary: Pythonic wrapper for the Google Sheets API
Provides: python-gsheets
BuildRequires: python3-devel
BuildRequires: python3-setuptools
BuildRequires: python3-pip
%description -n python3-gsheets
|PyPI version| |License| |Supported Python| |Wheel|
|Build| |Codecov| |Readthedocs-stable| |Readthedocs-latest|
``gsheets`` is a small wrapper around the `Google Sheets API`_ (v4) to provide
more convenient access to `Google Sheets`_ from Python scripts.
`Turn on the API`_, download an OAuth client ID as JSON file, and create a
``Sheets`` object from it. Use its index access (``__getitem__``) to retrieve
SpreadSheet objects by their id, or use ``.get()`` with a sheet URL.
Iterate over the ``Sheets`` object for all spreadsheets, or fetch spreadsheets
by title with the ``.find()`` and ``.findall()`` methods.
SpreadSheet objects are collections of WorkSheets, which provide access to the
cell values via spreadsheet coordinates/slices (e.g. ``ws['A1']``) and
zero-based cell position (e.g. ``ws.at(0, 1)``).
Save WorkSheets (or all from a SpreadSheet) as CSV files with the
``.to_csv()``-method. Create ``pandas.DataFrames`` from worksheet with the
``.to_frame()``-method.
%package help
Summary: Development documents and examples for gsheets
Provides: python3-gsheets-doc
%description help
|PyPI version| |License| |Supported Python| |Wheel|
|Build| |Codecov| |Readthedocs-stable| |Readthedocs-latest|
``gsheets`` is a small wrapper around the `Google Sheets API`_ (v4) to provide
more convenient access to `Google Sheets`_ from Python scripts.
`Turn on the API`_, download an OAuth client ID as JSON file, and create a
``Sheets`` object from it. Use its index access (``__getitem__``) to retrieve
SpreadSheet objects by their id, or use ``.get()`` with a sheet URL.
Iterate over the ``Sheets`` object for all spreadsheets, or fetch spreadsheets
by title with the ``.find()`` and ``.findall()`` methods.
SpreadSheet objects are collections of WorkSheets, which provide access to the
cell values via spreadsheet coordinates/slices (e.g. ``ws['A1']``) and
zero-based cell position (e.g. ``ws.at(0, 1)``).
Save WorkSheets (or all from a SpreadSheet) as CSV files with the
``.to_csv()``-method. Create ``pandas.DataFrames`` from worksheet with the
``.to_frame()``-method.
%prep
%autosetup -n gsheets-0.6.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-gsheets -f filelist.lst
%dir %{python3_sitelib}/*
%files help -f doclist.lst
%{_docdir}/*
%changelog
* Mon Apr 10 2023 Python_Bot <Python_Bot@openeuler.org> - 0.6.1-1
- Package Spec generated
|
