The On line Google Spreadsheet (GS) allows one to create and edit spreadsheets on the Internet without the need of a dedicated program like MS Excel.
GS, at this moment, lacks an API to extend its use on the client machine. The user can only save his spreadsheet in several format for further editing and data reduction.
Since that one of the save format is HTML I though to use Greasemonkey for further on line processing.
This script is only a proof of concept to see how GM can be used in this context. It's also my first GM script...
The goal is to print addresses from a contact list in the spreadsheet on envelopes or labels sheets. I extended it to print form letters for each address. For that, as also for the inclusion of user's images, one needs to rewrite the script with these inclusions. So I wrote an external program that produce the GM script dynamically.
The script has been tested on windows,Mac and Linux (Ubuntu) with Firefox 1.5.
NEW VERSION:
10/5/2006 1:26PM
This is a new version of my previous Divamail user script. The improvements are:
1.- Use the 'export csv' instead of 'export html': This corrects the problems from GS changing its exported html format.
2.- Add a 'select column' for selection of addresses printing either manually or via a formula.
3.- User can save his/her script under a different name, corresponding to contact type (Personal, business..)
or to type of form letter for example. So it can be used again.
4.- Control of printing Zip code bars.
Supported labels are 6,20 and 30 labels per page (Avry format). Envelopes: #10 format
The Greasemonkey script runs on Firefox 1.5+ (Window,Mac and Linux platforms) and maybe on Opera browser.
I will see if it can be adapted to Internet Explorer later on.
