To Fetch DataFrame from Google Spreadsheet Excel without auth/ password.
Project description
Googlexcel_noPassword
_____________________________________________First package (probably) built to easily obtain the data within an entire shared Google Spreadsheet without passing Google username/ password or credentials.json.
Instructions.
To install the package, perform:
pip install Googlexcel_noPassword
How to use the methods:
- To obtain the list of sheetnames:
#url_GoogleSheets = The shared url of Google Spreadsheet document. (Ensure that the privilege is set to 'Anyone with the link'.)
list_ofSheetnames = fetch_sheetnameslist(url_GoogleSheets)
- 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 = dataframe_AllSheets(url_GoogleSheets)
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
Built Distribution
Close
Hashes for Googlexcel_noPassword-0.0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | af843ed0d13a4dd0598ed35e38b53d36d3789a0659c8c8a4a72d700aafc9f1ae |
|
MD5 | 8fb8720f0bfa657736eed3154a43933e |
|
BLAKE2b-256 | c01d763c57723d68ccc138649cc8ed25c2a4bc460c1294722d3f9aea9edb9c55 |
Close
Hashes for Googlexcel_noPassword-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 565f1494764f6141c0a86893726eb8d0d421a11439c799a2ed3fb345169f4848 |
|
MD5 | d62a920d0cab4b40166609c071f3f5f6 |
|
BLAKE2b-256 | 1f8515055b945d92970f815fa1ebac636b6c937a6b21214c74bcc735b8cfb907 |