Easy pasting of CSV files to Google Sheets.
Project description
Manages .csv files and uploads or pastes them to Google Sheets.
Usage
Installation
With Python installed, and in a command window, enter: pip install gcsv
Code
Use the following code example as a guide, replacing the following dummy strings with relevant information.
- my_csv_path: the path to your CSV (e.g C:\reports\mycsv.csv)
- my_spreadsheet_id: the ID (or “key”) of a spreadsheet; can be found in the spreadsheet URL after /d/ but before /edit
- my_worksheet_gid: the worksheet (or “tab”) name of the paste destination
- start_row: the starting row of the paste destination
- start_col: the starting column of the paste destination
import gcsv csv = gcsv.GCSV(r'my_csv_path') csv.paste_to('my_spreadsheet_id', my_worksheet_gid, start_row, start_col)
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.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size gcsv-0.1.0-py3-none-any.whl (6.7 kB) | File type Wheel | Python version py3 | Upload date | Hashes View |
Filename, size gcsv-0.1.0.tar.gz (3.4 kB) | File type Source | Python version None | Upload date | Hashes View |