python-barcode-spreadSheet

python-barcode-spreadSheet

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

Pre-requisites

• gspread https://github.com/burnash/gspread/
• pyBarcode https://pypi.python.org/pypi/pyBarcode/

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

Usage

Import the script::

import BarcodePythonScript as bps

Logging into the spreadsheet client::

client=bps.spreadsheet_login(your_google_email, your_google_password)
    

Generating bar-code::

bps.BarcodeGen(barcode_type, barcode_gen_value, image_name)
    

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:
Code 39, PZN, EAN-13, EAN-8, JAN, ISBN-13, ISBN-10, ISSN, UPC-A

Writing bar-code image to spreadsheet::

	bps.BarcodeWrite(client, spreadsheet_key, image_url, cell_id, sheet_id)

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