path: root/python-gspread10.spec

%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.aliyun.com/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
* Thu Jun 08 2023 Python_Bot <Python_Bot@openeuler.org> - 0.0.2-1
- Package Spec generated