%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