go>> python-spreadsheet-updater>> 返回
项目作者： SiddiqMohammed

项目描述 ：
Update Google Spreadsheets using inputs from Python
高级语言： Python
项目地址: git://github.com/SiddiqMohammed/python-spreadsheet-updater.git
创建时间： 2019-04-28T01:09:23Z
项目社区：https://github.com/SiddiqMohammed/python-spreadsheet-updater
开源协议：MIT License
下载


Python Spreadsheet updater

Using the google spreadsheets API, gspread library, and pyqt5, I’ve made a simple spreadsheet updater.

A dialog box opens up and asks the user for the data that is supposed to be updated in the spreadsheet online. When the user writes the data and submits, the spreadsheet is updated automatically.

Installation

Use the package manager pip to install the libraries.

  1. pip install gspread 
  2. pip install pyqt5

Usage

  1. from oauth2client.service_account import ServiceAccountCredentials
  2. from pprint import pprint

  1. Set up to get the API access. To gain the access, go to the “google cloud platform” and create a new project and install and enable the “google drive” & “spreadsheet” which can be found in the library section.

  2. Get the JSON file from your API. This JSON file contains all your credentials that allow the API to connect and interact with your code. I named my JSON file “creds”

  3. Create a new spreadsheet and name it and share it with the “client-ID” email that you receive in the JSON file from the API

If you want to create a GUI with custom dialog boxes then I suggest you to learn to use pyqt5. It is a great tool that is in my opinion much better than the alternatives that I’ve come across.

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT