Skip to main content

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

Project description

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

Pre-requisites

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

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.3.tar.gz (1.7 kB view hashes)

Uploaded Source

Supported by

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