automatic import of python-gspread10

3 files changed, 453 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..1e3845c 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/gspread10-0.0.2.tar.gz
diff --git a/python-gspread10.spec b/python-gspread10.spec
new file mode 100644
index 0000000..e0dd375
--- /dev/null
+++ b/python-gspread10.spec
@@ -0,0 +1,451 @@
+%global _empty_manifest_terminate_build 0
+Name:		python-gspread10
+Version:	0.0.2
+Release:	1
+Summary:	Package which helps us to read the data from google sheets
+License:	MIT
+URL:		https://github.com/abhi10sharma/Gspread-Sheets
+Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/8b/95/3633ddfef0ec3060a69430cd59f6b58b68cc9e8fef8719163885e7678148/gspread10-0.0.2.tar.gz
+BuildArch:	noarch
+
+Requires:	python3-gspread
+Requires:	python3-oauth2client
+Requires:	python3-pandas
+Requires:	python3-matplotlib
+
+%description
+
+# GSPREAD10
+
+![Sheets to Python](https://twilio-cms-prod.s3.amazonaws.com/original_images/python-and-sheets.png)
+
+# Introduction
+
+This is an python package which helps us to read the data of google spread sheets from your google drive and then you can manipulate the data using [pandas](https://pypi.org/project/pandas/) and plot graph using [matplotlib](https://pypi.org/project/matplotlib/)
+***
+
+## Features
+
+1. Easy to use
+2. Easy to understand
+3. Very helpful for reading the data from Google Sheets
+
+# Inside the Package
+
+Before installing this package there is one important thing which you have to do first. You have to enable your Google Drive API and Google Sheets API from [Google APIs Console](console.developers.google.com).
+
+## Steps to enable [Google Drive API](https://www.google.com/intl/en_in/drive/)
+
+1. Go to the [Google APIs Console](https://console.developers.google.com/).
+2. Create a new project.
+3. Click Enable API. Search for and enable the Google Drive API.
+4. Create credentials for a Web Server to access Application Data.
+5. Name the service account and grant it a Project Role of Editor.
+6. Download the [JSON](https://www.json.org/json-en.html) file.
+7. Give any specfic name of your [JSON](https://www.json.org/json-en.html) file
+8. Then Search [Google Sheets API](https://developers.google.com/sheets/api) and then click on enable.
+9. Open your [JSON](https://www.json.org/json-en.html) file and copy the client_email.
+10. Open your [GOOGLE SPREADSHEETS](https://www.google.com/sheets/about/) and click on share button on the right top.
+11. Paste your client_email and then click on send button.
+
+# Code Description
+
+## Library Used
+
+I have used the [gspread](https://pypi.org/project/gspread/) and [oauth2client](https://pypi.org/project/oauth2client/) service to authorize and make API calls to Google Cloud Services.
+
+### Importing Library
+
+```python
+pip install gspread oauth2client
+pip install pandas
+```
+
+### Features of **`gspread`** library
+
+1. Google Sheets API v4.
+2. Open a spreadsheet by title, key or url.
+3. Read, write, and format cell ranges.
+4. Sharing and access control.
+5. Batching updates.
+
+### About **`oauth2client`**
+
+This library will help us to get the client credientials a to read the data of specific Spread Sheet.
+***
+
+# LET'S GET STARTED
+
+# How to Install
+
+```python
+ pip install gspread10
+```
+
+The name of this package is "gspread10" and you can use this package to read the data from [GOODLE SPREADSHEETS](https://www.google.com/sheets/about/) in [JSON](https://www.json.org/json-en.html) format and then using [pandas](https://pypi.org/project/pandas/) you can manipulate the data in table using [DataFrames](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html) and for Data Visualization you can use [Matplotlib](https://pypi.org/project/matplotlib/).
+
+## Function to read the data
+
+To read the data from c you have to use `getjsonGspreadData(json_file, gspread_file)` function and inside the function you have to give the path of your [JSON](https://www.json.org/json-en.html) file and the name of your [GOODLE SPREADSHEETS](https://www.google.com/sheets/about/).
+For example:- I want to read the data from [Greendeck](https://www.greendeck.co/) Assignment file. So Here How it should be written.
+
+``` Python
+getjsonGspreadData("your_JSON_Path", "Greendeck Assignment")
+```
+
+# Code for Reading the file from [GOOGLE SPREADSHEETS](https://www.google.com/sheets/about/)
+
+```Python
+# Google Sheets Features.
+# Open a spreadsheet by title, key or url.
+# Read, write, and format cell ranges.
+# Sharing and access control.
+# Batching updates.
+
+# oauth2client library will help us to get the client credentials a to read the data of specific Spread Sheet.
+
+import gspread
+from oauth2client.service_account import ServiceAccountCredentials
+import pandas as pd
+
+def getjsonGspreadData(json_file, gspread_file):
+    # use creds to create a client to interact with the Google Drive API
+    scope = ["https://spreadsheets.google.com/feeds","https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
+    creds = ServiceAccountCredentials.from_json_keyfile_name(json_file, scope)
+    client = gspread.authorize(creds)
+    # Find a workbook by name and open the first sheet
+    # Make sure you use the right name here.
+
+    sheet = client.open(gspread_file).sheet1
+
+    # Extract and print all of the values
+    list_of_gspread = sheet.get_all_records()
+    # return list_of_gspread
+    data = pd.DataFrame.from_dict(list_of_gspread)
+    return data
+
+# print(getjsonGspreadData("D:\\project videos\\Google sheets\\client_secret.json", "Greendeck Assignment"))
+
+```
+
+I went throung several websites to get the idea of 'How to read data from Google Spread Sheet'. So finally I got this website --> [medium.com](https://medium.com/analytics-vidhya/how-to-read-and-write-data-to-google-spreadsheet-using-python-ebf54d51a72c). You can go through this website.
+
+# License
+
+This package is distributed under the [MIT license](https://opensource.org/licenses/MIT).
+
+# Download
+
+[https://pypi.org/project/gspread10/0.0.1/](https://pypi.org/project/gspread10/0.0.1/)
+
+
+
+
+%package -n python3-gspread10
+Summary:	Package which helps us to read the data from google sheets
+Provides:	python-gspread10
+BuildRequires:	python3-devel
+BuildRequires:	python3-setuptools
+BuildRequires:	python3-pip
+%description -n python3-gspread10
+
+# GSPREAD10
+
+![Sheets to Python](https://twilio-cms-prod.s3.amazonaws.com/original_images/python-and-sheets.png)
+
+# Introduction
+
+This is an python package which helps us to read the data of google spread sheets from your google drive and then you can manipulate the data using [pandas](https://pypi.org/project/pandas/) and plot graph using [matplotlib](https://pypi.org/project/matplotlib/)
+***
+
+## Features
+
+1. Easy to use
+2. Easy to understand
+3. Very helpful for reading the data from Google Sheets
+
+# Inside the Package
+
+Before installing this package there is one important thing which you have to do first. You have to enable your Google Drive API and Google Sheets API from [Google APIs Console](console.developers.google.com).
+
+## Steps to enable [Google Drive API](https://www.google.com/intl/en_in/drive/)
+
+1. Go to the [Google APIs Console](https://console.developers.google.com/).
+2. Create a new project.
+3. Click Enable API. Search for and enable the Google Drive API.
+4. Create credentials for a Web Server to access Application Data.
+5. Name the service account and grant it a Project Role of Editor.
+6. Download the [JSON](https://www.json.org/json-en.html) file.
+7. Give any specfic name of your [JSON](https://www.json.org/json-en.html) file
+8. Then Search [Google Sheets API](https://developers.google.com/sheets/api) and then click on enable.
+9. Open your [JSON](https://www.json.org/json-en.html) file and copy the client_email.
+10. Open your [GOOGLE SPREADSHEETS](https://www.google.com/sheets/about/) and click on share button on the right top.
+11. Paste your client_email and then click on send button.
+
+# Code Description
+
+## Library Used
+
+I have used the [gspread](https://pypi.org/project/gspread/) and [oauth2client](https://pypi.org/project/oauth2client/) service to authorize and make API calls to Google Cloud Services.
+
+### Importing Library
+
+```python
+pip install gspread oauth2client
+pip install pandas
+```
+
+### Features of **`gspread`** library
+
+1. Google Sheets API v4.
+2. Open a spreadsheet by title, key or url.
+3. Read, write, and format cell ranges.
+4. Sharing and access control.
+5. Batching updates.
+
+### About **`oauth2client`**
+
+This library will help us to get the client credientials a to read the data of specific Spread Sheet.
+***
+
+# LET'S GET STARTED
+
+# How to Install
+
+```python
+ pip install gspread10
+```
+
+The name of this package is "gspread10" and you can use this package to read the data from [GOODLE SPREADSHEETS](https://www.google.com/sheets/about/) in [JSON](https://www.json.org/json-en.html) format and then using [pandas](https://pypi.org/project/pandas/) you can manipulate the data in table using [DataFrames](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html) and for Data Visualization you can use [Matplotlib](https://pypi.org/project/matplotlib/).
+
+## Function to read the data
+
+To read the data from c you have to use `getjsonGspreadData(json_file, gspread_file)` function and inside the function you have to give the path of your [JSON](https://www.json.org/json-en.html) file and the name of your [GOODLE SPREADSHEETS](https://www.google.com/sheets/about/).
+For example:- I want to read the data from [Greendeck](https://www.greendeck.co/) Assignment file. So Here How it should be written.
+
+``` Python
+getjsonGspreadData("your_JSON_Path", "Greendeck Assignment")
+```
+
+# Code for Reading the file from [GOOGLE SPREADSHEETS](https://www.google.com/sheets/about/)
+
+```Python
+# Google Sheets Features.
+# Open a spreadsheet by title, key or url.
+# Read, write, and format cell ranges.
+# Sharing and access control.
+# Batching updates.
+
+# oauth2client library will help us to get the client credentials a to read the data of specific Spread Sheet.
+
+import gspread
+from oauth2client.service_account import ServiceAccountCredentials
+import pandas as pd
+
+def getjsonGspreadData(json_file, gspread_file):
+    # use creds to create a client to interact with the Google Drive API
+    scope = ["https://spreadsheets.google.com/feeds","https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
+    creds = ServiceAccountCredentials.from_json_keyfile_name(json_file, scope)
+    client = gspread.authorize(creds)
+    # Find a workbook by name and open the first sheet
+    # Make sure you use the right name here.
+
+    sheet = client.open(gspread_file).sheet1
+
+    # Extract and print all of the values
+    list_of_gspread = sheet.get_all_records()
+    # return list_of_gspread
+    data = pd.DataFrame.from_dict(list_of_gspread)
+    return data
+
+# print(getjsonGspreadData("D:\\project videos\\Google sheets\\client_secret.json", "Greendeck Assignment"))
+
+```
+
+I went throung several websites to get the idea of 'How to read data from Google Spread Sheet'. So finally I got this website --> [medium.com](https://medium.com/analytics-vidhya/how-to-read-and-write-data-to-google-spreadsheet-using-python-ebf54d51a72c). You can go through this website.
+
+# License
+
+This package is distributed under the [MIT license](https://opensource.org/licenses/MIT).
+
+# Download
+
+[https://pypi.org/project/gspread10/0.0.1/](https://pypi.org/project/gspread10/0.0.1/)
+
+
+
+
+%package help
+Summary:	Development documents and examples for gspread10
+Provides:	python3-gspread10-doc
+%description help
+
+# GSPREAD10
+
+![Sheets to Python](https://twilio-cms-prod.s3.amazonaws.com/original_images/python-and-sheets.png)
+
+# Introduction
+
+This is an python package which helps us to read the data of google spread sheets from your google drive and then you can manipulate the data using [pandas](https://pypi.org/project/pandas/) and plot graph using [matplotlib](https://pypi.org/project/matplotlib/)
+***
+
+## Features
+
+1. Easy to use
+2. Easy to understand
+3. Very helpful for reading the data from Google Sheets
+
+# Inside the Package
+
+Before installing this package there is one important thing which you have to do first. You have to enable your Google Drive API and Google Sheets API from [Google APIs Console](console.developers.google.com).
+
+## Steps to enable [Google Drive API](https://www.google.com/intl/en_in/drive/)
+
+1. Go to the [Google APIs Console](https://console.developers.google.com/).
+2. Create a new project.
+3. Click Enable API. Search for and enable the Google Drive API.
+4. Create credentials for a Web Server to access Application Data.
+5. Name the service account and grant it a Project Role of Editor.
+6. Download the [JSON](https://www.json.org/json-en.html) file.
+7. Give any specfic name of your [JSON](https://www.json.org/json-en.html) file
+8. Then Search [Google Sheets API](https://developers.google.com/sheets/api) and then click on enable.
+9. Open your [JSON](https://www.json.org/json-en.html) file and copy the client_email.
+10. Open your [GOOGLE SPREADSHEETS](https://www.google.com/sheets/about/) and click on share button on the right top.
+11. Paste your client_email and then click on send button.
+
+# Code Description
+
+## Library Used
+
+I have used the [gspread](https://pypi.org/project/gspread/) and [oauth2client](https://pypi.org/project/oauth2client/) service to authorize and make API calls to Google Cloud Services.
+
+### Importing Library
+
+```python
+pip install gspread oauth2client
+pip install pandas
+```
+
+### Features of **`gspread`** library
+
+1. Google Sheets API v4.
+2. Open a spreadsheet by title, key or url.
+3. Read, write, and format cell ranges.
+4. Sharing and access control.
+5. Batching updates.
+
+### About **`oauth2client`**
+
+This library will help us to get the client credientials a to read the data of specific Spread Sheet.
+***
+
+# LET'S GET STARTED
+
+# How to Install
+
+```python
+ pip install gspread10
+```
+
+The name of this package is "gspread10" and you can use this package to read the data from [GOODLE SPREADSHEETS](https://www.google.com/sheets/about/) in [JSON](https://www.json.org/json-en.html) format and then using [pandas](https://pypi.org/project/pandas/) you can manipulate the data in table using [DataFrames](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html) and for Data Visualization you can use [Matplotlib](https://pypi.org/project/matplotlib/).
+
+## Function to read the data
+
+To read the data from c you have to use `getjsonGspreadData(json_file, gspread_file)` function and inside the function you have to give the path of your [JSON](https://www.json.org/json-en.html) file and the name of your [GOODLE SPREADSHEETS](https://www.google.com/sheets/about/).
+For example:- I want to read the data from [Greendeck](https://www.greendeck.co/) Assignment file. So Here How it should be written.
+
+``` Python
+getjsonGspreadData("your_JSON_Path", "Greendeck Assignment")
+```
+
+# Code for Reading the file from [GOOGLE SPREADSHEETS](https://www.google.com/sheets/about/)
+
+```Python
+# Google Sheets Features.
+# Open a spreadsheet by title, key or url.
+# Read, write, and format cell ranges.
+# Sharing and access control.
+# Batching updates.
+
+# oauth2client library will help us to get the client credentials a to read the data of specific Spread Sheet.
+
+import gspread
+from oauth2client.service_account import ServiceAccountCredentials
+import pandas as pd
+
+def getjsonGspreadData(json_file, gspread_file):
+    # use creds to create a client to interact with the Google Drive API
+    scope = ["https://spreadsheets.google.com/feeds","https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
+    creds = ServiceAccountCredentials.from_json_keyfile_name(json_file, scope)
+    client = gspread.authorize(creds)
+    # Find a workbook by name and open the first sheet
+    # Make sure you use the right name here.
+
+    sheet = client.open(gspread_file).sheet1
+
+    # Extract and print all of the values
+    list_of_gspread = sheet.get_all_records()
+    # return list_of_gspread
+    data = pd.DataFrame.from_dict(list_of_gspread)
+    return data
+
+# print(getjsonGspreadData("D:\\project videos\\Google sheets\\client_secret.json", "Greendeck Assignment"))
+
+```
+
+I went throung several websites to get the idea of 'How to read data from Google Spread Sheet'. So finally I got this website --> [medium.com](https://medium.com/analytics-vidhya/how-to-read-and-write-data-to-google-spreadsheet-using-python-ebf54d51a72c). You can go through this website.
+
+# License
+
+This package is distributed under the [MIT license](https://opensource.org/licenses/MIT).
+
+# Download
+
+[https://pypi.org/project/gspread10/0.0.1/](https://pypi.org/project/gspread10/0.0.1/)
+
+
+
+
+%prep
+%autosetup -n gspread10-0.0.2
+
+%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-gspread10 -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Mon May 15 2023 Python_Bot <Python_Bot@openeuler.org> - 0.0.2-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..05cdee4
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+f90fc0522a92e5d3f7ba002a3e65e76a  gspread10-0.0.2.tar.gz