Re: FYI: getting data from an OpenOffice.org spreadsheet

2006-09-03 Thread Sybren Stuvel
John Machin enlightened us with: > Firstly, let me say that you are highly commended for wading so far > into the OOo docs and producing two pieces of code that actually do > something. I've opened up the docs two or three times, said "Waaahht > the " and closed them rapidly. Thanks. I had the

Re: FYI: getting data from an OpenOffice.org spreadsheet

2006-09-03 Thread John Machin
Sybren Stuvel wrote: > John Machin enlightened us with: > > Suppose one has over a hundred spreadsheets (real-life example: > > budgets from an organisation's reporting centres) ... manually > > opening each in OOo Calc is less than appealing, and not very > > robust. > > True. There are functions

Re: FYI: getting data from an OpenOffice.org spreadsheet

2006-09-03 Thread Sybren Stuvel
John Machin enlightened us with: > Suppose one has over a hundred spreadsheets (real-life example: > budgets from an organisation's reporting centres) ... manually > opening each in OOo Calc is less than appealing, and not very > robust. True. There are functions that can load files as well. Combi

Re: FYI: getting data from an OpenOffice.org spreadsheet

2006-09-03 Thread John Machin
Sybren Stuvel wrote: > Hi folks, > > Sometimes I have to feed data from an OpenOffice.org spreadsheet into > some Python program. To make that really easy, I've written a small > example program that connects to a running OpenOffice.org instance and > reads the data from the currently opened spread

Re: FYI: getting data from an OpenOffice.org spreadsheet

2006-09-03 Thread Sybren Stuvel
Hi folks, I just noticed I still had the "no archive" header on, which is rather stupid. If I want to make life easier for people, the information I posted in this thread should be archived! Here is a small summary: Get data from an OpenOffice.org spreadsheet with a Python script. It works on the

Re: FYI: getting data from an OpenOffice.org spreadsheet

2006-09-03 Thread alf
Sybren Stuvel wrote: > Hi folks, > > Sometimes I have to feed data from an OpenOffice.org spreadsheet into > some Python program. To make that really easy, I've written a small > example program that connects to a running OpenOffice.org instance and > reads the data from the currently opened sprea