Fetch all sheets of data from Google Spreadsheet Excel without auth/ password.
Project description
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Googlexcel_noPassword-1.11.tar.gz
(16.3 kB
view hashes)
Built Distribution
Close
Hashes for Googlexcel_noPassword-1.11.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6d491909df4e934f6edb98d9d3a8868df7f178c8734e88a7a8e419523aaf1aee |
|
MD5 | 2220b8b9edd2d38fe5f5d776805d8904 |
|
BLAKE2b-256 | 458c8ca70c2098b02ac8eff0f43f6ee50d0e86b7cdc699d76e238e630cf8b4b7 |
Close
Hashes for Googlexcel_noPassword-1.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 01d7700a928616ccb3175ff0ed34a0750872675f55f2b1799738cbc2816fb54e |
|
MD5 | 53f45455094f1352badec8b57dbcfe07 |
|
BLAKE2b-256 | 30b53016c9a403ee12ef55cca7bf7dcc4aa59897b74260ea4253209fb3ac52c7 |