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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

python-barcode-spreadSheet-1.1.0.tar.gz (1.8 kB view details)

Uploaded Source

File details

Details for the file python-barcode-spreadSheet-1.1.0.tar.gz.

File metadata

File hashes

Hashes for python-barcode-spreadSheet-1.1.0.tar.gz
Algorithm Hash digest
SHA256 cee1de9e0d8ea44b0ba599e69d4f1b44fb5070a3bbbdbbf3a70619b19f9a4f8d
MD5 e998fb36bf8573e84920be6782aef58f
BLAKE2b-256 033ca415788d41254fce0fbf47c500b5f4e4d31cc060e18db497660cd90a9d01

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page