Skip to main content

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 &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).

Project details


Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page