[fpc-pascal] read cells contents from .xls file

[Felipe Monteiro de Carvalho]

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 storage system to start
with, which is something pretty complex.

BIFF2 till BIFF5 (Excel 5.0) were simple formats, but that's not the
format you are looking for from your question.

Felipe

On Mon, Sep 30, 2013 at 9:45 PM, John Lee <johnelee0 at gmail.com> wrote:
> 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 some info for a quick hack eg some bullets or some
> idea what I need to do eg to read the no or string in eg cell x23 of sheet
> jim in fred.xls.
>
> John
>
>
>
>
>
>
> On 30 September 2013 16:38, Felipe Monteiro de Carvalho
> <felipemonteiro.carvalho at gmail.com> wrote:
>>
>> 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 <johnelee0 at gmail.com> 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 fight
>> > with
>> > the complexities of the lazarus based stuff. Prepared to experiment...
>> >
>> > TIA John
>> >
>> >
>> >
>> > _______________________________________________
>> > fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
>> > http://lists.freepascal.org/mailman/listinfo/fpc-pascal
>>
>>
>>
>> --
>> Felipe Monteiro de Carvalho
>> _______________________________________________
>> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
>> http://lists.freepascal.org/mailman/listinfo/fpc-pascal
>
>
>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-pascal



-- 
Felipe Monteiro de Carvalho