Yep, I found that earlier when I was looking. Perhaps I should've mentioned it... Oh well, too late now :D.
There is a problem though. That has low level xml parser for odf in general (OpenOffice::OODoc::XPath). Which would enable me to do what I want. However it would be quite a task as it is a low level xml parser for odf. There are some higher level modules in the OpenOffice::OODoc. However the main high level one is for text documents and not for spreadsheets. And that's a problem.
But I hadn't seen that newsletter. Interesting... thanks for that. | [reply] |
Hena,
Did you read OpenOffice::OODoc? It mentions text2table which comes as part of the distribution:
"Creates an OpenOffice.org Calc file and populate its first sheet from a delimited text file. Each line of the source file produces a row in the target table. In the line, the field separator is ";"."
Since you already have a method of outputting your data in a delimited format, perhaps this would be of use to you.
Martin
| [reply] |
I actually hadn't noticed that thanks.
But then I would have to recreate the entire file again. And I noticed that it just makes one sheet. I would like to add a sheet or two and modify the first sheet (which holds the basic information from the entire tournament).
Also I need to be able to read the needed columns from the first sheet to get the info I'm using to calculate next turn.
| [reply] |