[Lazarus] Reading a spreadsheet with fpspreadsheet

[Koenraad Lelon]

Op 29-07-10 16:30, Michael Van Canneyt schreef:
> 
> 
> On Thu, 29 Jul 2010, Felipe Monteiro de Carvalho wrote:
> 
>> Ah, excel 5+ binary format is terrible ... I would be more inclined to
>> fix something readable like OpenDocument or OOXML. You can use
>> OpenOffice which is free to convert a XLS to OpenDocument.
> 
> 
> Strange advise. OpenOffice is not always available to the end user where
> the program must run ?
> 
> Michael.
> 
Hi,

I tried with excel2read, and that application does not crash, it gives
no data back though.

My application would be a transcoder. I get excel-files from a customer,
and I need a csv-like output. This is read by a proprietary application.
What I do now is read the excel-file in OOo or MS-Excel, save it as csv
and, with an editor, I fix the file (with a bunch of replaces) so that
the prop. application can read the file.
I would like to automate this : just read the excel-file and have the
output-file ready to read.
I could start from OOo format, it would be one step more than I would
like, but a lot less work than now.

I'll have a look at the OOo demo's.

Thanks,

Koenraad Lelong.