Skip to main content

Read en excel file throgh google drive and plot it

Project description


|PyPI version| |License| |Supported Python| |Format|

gsheets is a small wrapper around the Google Sheets API_ (v4) to provide more convenient access to Google Sheets_ from Python scripts.

go to google console
1.Create a Project in google cloud
2.through Navigation menu Go ti API'S & Services and go to library for google sheets api and enable it for google drive api enable it and on the right side corner click on create credentials select google drive api in which api you are using column and web server (eg node js tomcat) in Where will you be calling the API from dropdown and tick on application data. and then no and press button
5.fill any name in account and role select project and then editor and type json and submit. it will download the json file . json file search client email go to google sheet you want to use and select share and give access to client email and send.



This package runs under Python 2.7, and 3.6+, use pip_ to install:

.. code:: bash

$ pip install read-excel

This will also install google-api-python-client_ and its dependencies, notably httplib2_ and oauth2client_, as required dependencies.


Log into the Google Developers Console_ with the Google account whose spreadsheets you want to access. Create (or select) a project and enable the Drive API and Sheets API (under Google Apps APIs).

Go to the Credentials for your project and create New credentials > OAuth client ID > of type Other. In the list of your OAuth 2.0 client IDs click Download JSON for the Client ID you just created. Save the file as client_secrets.json in your home directory (user directory).

import the library and load the data by passing the filename and json file downloaded from console it will return a dataframe and print top 5 rows of your data:

.. code:: python

>>> import read-excel as rf

>>> dataframe = rf.load_data(filename_of_your_sheet,json_path)

For plotting the data you have to pass the dataframe you just loaded and pass the name X axis columns name and Y axis column name it will plot the data for you:

.. code:: python

for plotting
>>> plot_data(dataframe,"x-axis-column","y-axis-column")


Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

exceldrive2py-0.0.1-py3-none-any.whl (15.5 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page