in reply to Re^3: ODF file handling
in thread ODF file handling

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.

Replies are listed 'Best First'.
Re^5: ODF file handling
by marto (Cardinal) on Jun 10, 2006 at 17:49 UTC
    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
      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.