1

I have the file created within "Open Office Calc" which I need to load into my C++ program to generate some game-specific code for which this design file was written. All I need is spreadsheets names, fields data and formulas results.

Is there a way to do so?

Thank you.

Slaus
  • 2,086
  • 4
  • 26
  • 41
  • 1
    All OpenOffice files are zip-archives, with the contents in publicly specified XML files. Might be some work but would not be impossible to get the data you need with the help of most available XML-parsers. – Some programmer dude Nov 21 '11 at 15:17
  • At first I thought such solution too complicated but after hours spent with OpenOfficeSDK which runs **calc** executable, creates some **pdb** and **registry** files (along with it's weird **hpp** sources generated from **hxx**), uses socket connection and installed OpenOffice version on target PC has to be the same as SDK version with which program was compiled. Can you post the same as answer so I could accept it? Thank you. – Slaus Nov 29 '11 at 09:55
  • 2
    I used minizip to unzip **ods** file and pugixml to read xml data (Office writes formula results into output XML too). There are just 400 lines of code. Don't think it even worth to share with somebody. – Slaus Nov 29 '11 at 10:16

1 Answers1

2

All OpenOffice files are zip-archives, with the contents in publicly specified XML files. Might be some work but would not be impossible to get the data you need with the help of most available XML-parsers.

Some programmer dude
  • 400,186
  • 35
  • 402
  • 621