Thanks for all suggestions. IMO fpspread...pas is too complex for & I'd
need to hack thro' thousands of lines - maybe a simple program to read xls
into csv, as in b) below could be added?.
Here, fyi, In looking around I came up with these 2 :
a) googled 'read xls'
http://exceldatareader.codeplex
Thanks - as you say (with nice irony) it isn't a simple format, and I don't
pretend to understand it, indeed it is 'doing my head in' - but I don't
want to write .xls or do charts etc, just read some cells (only in in excel
2003, seems to be v11 according to help) - maybe my hope of a few lines,
The source code of fpspreadsheet is open ... just copy/paste/modifiy
it for your needs:
https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/fpspreadsheet/xlsbiff8.pas#l50
But BIFF8 is not a simple format, there is no simple answer to your
question. It is encapsulated in a OLE Document
Thanks - that looks excellent, but the 'uses' list for this, for non
lazarus users, has, I guess, lots of things in it.
The problem is also that I'm trying to implement this hack in an old
version of pascal, v2.2.2 for which I only have the compiler & basic rtl
stuff - that's why I'd just like som
You mean like this library does? http://wiki.freepascal.org/FPSpreadsheet
Felipe Monteiro de Carvalho
On Mon, Sep 30, 2013 at 5:33 PM, John Lee wrote:
> File produced by excel 2003. Can anyone tell me the basic ideas, formats,
> pitfalls - I'd just like to write a short routine & don't want to f
File produced by excel 2003. Can anyone tell me the basic ideas, formats,
pitfalls - I'd just like to write a short routine & don't want to fight
with the complexities of the lazarus based stuff. Prepared to experiment...
TIA John
___
fpc-pascal maillist
