Looking for a tool for spreadsheet manipulation.

Andy Bair pab at korelogic.com
Wed Jan 19 16:16:53 EST 2011


On Wed, Jan 19, 2011 at 02:13:58PM -0500, David Berube wrote:
> On 01/19/2011 01:51 PM, Brian St. Pierre wrote:
> > Google provides an API for Google Spreadsheets:
> >      http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html
> >
> > and a python client library:
> >
> >      http://code.google.com/p/gdata-python-client/
> >
> > -Brian
> > _______________________________________________
> 
> Alternatively, instead of editing the document, you could edit a CSV 
> text file, tab delimited text file, or database table and then generate 
> your XLS/google doc document from that - which is likely your most 
> flexible approach, and still preserves your ability to have your 
> preferred output format.

I have used this technique with great success using the perl module
Spreadsheet::WriteExcel.  It's really easy and worth a look.

Andy

KoreLogic Security
603.465.3236 (Office)
603.340.2498 (Mobile)
http://www.korelogic.com
GnuPG Fingerprint: 688A 79EC B1E5 5748 CE87  1F20 2C45 60E7 0583 23B6
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 196 bytes
Desc: not available
Url : http://mail.gnhlug.org/mailman/private/gnhlug-discuss/attachments/20110119/f0ccf5ec/attachment.bin 


More information about the gnhlug-discuss mailing list