Googlexcel-noPassword 1.11

Fetch all sheets of data from Google Spreadsheet Excel without auth/ password.

Googlexcel_noPassword

_____________________________________________

The First package built to easily obtain the data within an entire shared Google Spreadsheet without passing Google username/ password, credentials.json or OTP authentication.

---

Instructions.

To install the package, perform:

pip install Googlexcel-noPassword

How to use the methods:

1. To obtain the list of sheetnames:

#Importing Library.
import Googlexcel-noPassword as ggx

#url_GoogleSheets = The shared url of Google Spreadsheet document. (Ensure that the privilege is set to 'Anyone with the link'.)
list_ofSheetnames = ggx.fetch_sheetnameslist(url_GoogleSheets)

2. To obtain the dictionary with 'Key' = Sheetname and 'Value' = DataFrame:

#Returns a dictionary with all the sheetnames and their respective data as dataframe.
dict_Dataframes = ggx.data_fromAllSheets(url_GoogleSheets)

3. To obtain a single dataframe from one sheet.

#Returns a dataframe for the data in one sheet.
df_sheetname = ggx.data_OneSheet(url_GoogleSheets, sheet_name)

---

Have fun with what is possibly the first library to bypass the credentials.json and the username/ password restrictions to fetch the entire Google Spreadsheet excel document.