gSheetsDataExtractor 0.0.1

Google sheets Data Extractor

gSheetsDataExtractor

Extracts data from google sheets and plots a chart with the values on the sheet. This library also gives the user an option to select the columns for x-axis and y-axis

Installation

Use pip to install the package

Python Version support

This package runs aunder python 3.6 and above versions

    $ pip install gSheetsDataExtractor

Quickstart

Sign into the Google Drive with the your Google account Open the spreadsheet you want to access and get the SpreadSheet ID from the link

Example

https://docs.google.com/spreadsheets/d/`1SrZfvr2ee54r7HR1jGtAE9zHIj_Y-UzK9ok8bdwkpqc`/edit#gid=0 The highlighted part in the above link will be the SpreadSheet ID

import the library and provide the input to the spreadSheetId and spreadSheetName:

• spreadSheetName can be any string without space

    >>> import gSheetsDataExtractor as de
    >>> spreadSheetId = input()
    >>> spreadSheetName = input()

For extracting the data and for plotting the chart with the values on the sheet, call the function extractData with googleSheetId and spreadSheetName as shown below:

	>>> de.extractData(spreadSheetId, spreadSheetName)

This prints the column names of the spreadsheet and gives the user to select the columns for x-axis and y-axis and plots the graph with the column names given by user.

License

This package is distributed under the MIT license.