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