python-barcode-spreadSheet 1.1.0

python-barcode-spreadSheet
==========================

A simple Python tool to generate bar-codes and programmatically insert them into Google Spreadsheets for printing.

<b>Pre-requisites: </b>

<ul>

<li>

gspread &nbsp;&nbsp;&nbsp;&nbsp; <a href="https://github.com/burnash/gspread">https://github.com/burnash/gspread</a>

</li>

<li>

pyBarcode &nbsp;&nbsp;&nbsp;&nbsp; <a href="https://pypi.python.org/pypi/pyBarcode">https://pypi.python.org/pypi/pyBarcode</a>

</li>

</ul>


Download and get the two plugins up and running before proceeding.


Usage
-----
Import the script:
<pre><code>import BarcodePythonScript as bps</code></pre>

Logging into the spreadsheet client:
<pre><code>client=bps.spreadsheet_login(your_google_email, your_google_password)</code></pre>

Generating bar-code:
<pre><code>bps.BarcodeGen(barcode_type, barcode_gen_value, image_name)</code></pre>
> where 'barcode_type' is the type of bar-code desired, 'barcode_gen_value' is the value to be used with the bar-code and 'image_name' is the desired name of the bar-code image PNG file.

####Types of bar-codes:
Here is a list: Code 39, PZN, EAN-13, EAN-8, JAN, ISBN-13, ISBN-10, ISSN, UPC-A

Writing barcode image to spreadsheet:
<pre><code>bps.BarcodeWrite(client, spreadsheet_key, image_url, cell_id, sheet_id)</code></pre>
> where 'client' is the spreadseet client, 'spreadsheet_key' is the key of the spreadsheet found in its URL. For example, in
'docs.google.com/spreadsheet/ccc?key=0AslEqHKkTxw1dGFSQmpyQnBKWXhYelRRQ3hldjFWS0E&amp;usp=sharing#gid=14',
the key is '0AslEqHKkTxw1dGFSQmpyQnBKWXhYelRRQ3hldjFWS0E'.
image_url is the absolute url of the image saved above, cell_id is the address of the spreadsheet cell where the bar-code is to be inserted (A21, F34, C6 etc) and sheet_id is the index of the sheet (0 being the first).