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

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 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

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. Combined

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 that can

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 same