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.

Files for python-barcode-spreadSheet, version 1.1.3
Filename, size File type Python version Upload date Hashes
Filename, size python-barcode-spreadSheet-1.1.3.tar.gz (1.7 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page