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


Release history Release notifications

This version
History Node

1.1.3

History Node

1.1.2

History Node

1.1.0

History Node

1.0.9

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
python-barcode-spreadSheet-1.1.3.tar.gz (1.7 kB) Copy SHA256 hash SHA256 Source None Apr 30, 2013

Supported by

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