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).
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
Close
Hashes for python-barcode-spreadSheet-1.1.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | cee1de9e0d8ea44b0ba599e69d4f1b44fb5070a3bbbdbbf3a70619b19f9a4f8d |
|
MD5 | e998fb36bf8573e84920be6782aef58f |
|
BLAKE2b-256 | 033ca415788d41254fce0fbf47c500b5f4e4d31cc060e18db497660cd90a9d01 |