Metadata-Version: 2.1
Name: gcsv
Version: 0.1.0
Summary: Easy pasting of CSV files to Google Sheets.
Home-page: https://github.com/liamCorbett/g-csv
License: MIT
Author: Liam Corbett
Requires-Python: >=3.7,<4.0
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.7
Requires-Dist: google-api-python-client (>=1.7,<2.0)
Requires-Dist: google-auth-httplib2 (>=0.0.3,<0.0.4)
Requires-Dist: google-auth-oauthlib (>=0.2.0,<0.3.0)
Project-URL: Repository, https://github.com/liamCorbett/g-csv
Description-Content-Type: text/x-rst

=====
g-csv
=====
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

.. code-block:: python

    import gcsv

    csv = gcsv.GCSV(r'my_csv_path')

    csv.paste_to('my_spreadsheet_id',
                 my_worksheet_gid,
                 start_row,
                 start_col)
