[plug] Slightly OT: library to read/write Excel data under Linux?

Leon Brooks leon at brooks.smileys.net
Sat Aug 26 22:03:51 WST 2000


Denis Brown wrote:
> The Linux-related part: I'd like to write (or have written -- hint, hint) a
> programme which examines the Excel sheet and parses the cell data,
> rewriting the sheet under a new name and flagging rouge formats with some
> sort of cell highlighting (red characters instead of black for example) and
> allowing them to be fixed by hand.   Auto-fix would be a nice pipe dream.
> In order for this to happen, I need to know if Linux-friendly Excel-reading
> C-libraries exist and if anyone on the list has +ve, -ve or other
> experiences with them.

I think gnumeric is scriptable enough to do this.

You might also want to try xl2html-ing (or using Excel to SaveAs in HTML) the
spreadsheet and then parsing the output of that.

-- 
How penguins survive: many are cold, but few are frozen.



More information about the plug mailing list