Convert OpenOffice.org Calc FODS XML to something meaningful
Get the code: The code in this blog post is now available at: http://github.com/tealeg/FODS2XML Background For a while now I’ve been receiving data in Excel files that needed to be integrated into some better structured XML data. Originally I was using a little xls2csv from the catdoc package in Arch Linux to pull the data from the horrible bloated XLS files into something usable. The trouble is the conversion to CSV was a little error prone and it’s really hard to see such errors in a 40MB CSV file....