A simple Python tool to generate bar-codes and programmatically insert them into Google Spreadsheets for printing.
Project description
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 <a href="https://github.com/burnash/gspread">https://github.com/burnash/gspread</a>
</li>
<li>
pyBarcode <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&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).
==========================
A simple Python tool to generate bar-codes and programmatically insert them into Google Spreadsheets for printing.
<b>Pre-requisites: </b>
<ul>
<li>
gspread <a href="https://github.com/burnash/gspread">https://github.com/burnash/gspread</a>
</li>
<li>
pyBarcode <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&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).