Is someone having Excel writing code without commate?

[Kukulkan]

Hi,

I'm looking for code for the generation of simple .xlsx files without using COM. The reason is that it has to work cross-platform.

As an .xlsx file is only a zipped XML container, maybe someone already is having PB code to simply export cells with text and numbers?

Thanks,

Kukulkan

[ebs]

Kukulkan,

Does it have to be .xlsx files? Can you use older .xls files?
If so, I have some code from Paul Squires (and adapted by ABBKlaus)that will write Excel BIFF 2.1 files without needing any COM/ADO/OLE.

Regards,
Eric

[Kukulkan]

Hi Eric,

if it is cross-platform (Win, Lin, Mac) and using PB functions only, I'm very interested.

Best,

Volker

[ebs]

Hi Volker,

Yes - it uses PB functions only. You can download "Excel_Writer105_PB46X86.zip" from http://www.rsbasic.de/backups/.

Regards,
Eric

[Michael Vogel]

You may have a look at a slightly enhanced version at this thread as well (only few things can be done but exporting data to a xls-file will be easily done)...

[Kukulkan]

Thank you Michael, I will give it a try...