Page 1 of 1
Is someone having Excel writing code without commate?
Posted: Fri Mar 10, 2017 12:35 pm
by 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
Re: Is someone having Excel writing code without commate?
Posted: Fri Mar 10, 2017 2:44 pm
by 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
Re: Is someone having Excel writing code without commate?
Posted: Fri Mar 10, 2017 3:11 pm
by Kukulkan
Hi Eric,
if it is cross-platform (Win, Lin, Mac) and using PB functions only, I'm very interested.
Best,
Volker
Re: Is someone having Excel writing code without commate?
Posted: Fri Mar 10, 2017 4:00 pm
by ebs
Hi Volker,
Yes - it uses PB functions only. You can download "Excel_Writer105_PB46X86.zip" from
http://www.rsbasic.de/backups/.
Regards,
Eric
Re: Is someone having Excel writing code without commate?
Posted: Fri Mar 10, 2017 4:31 pm
by 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)...
Re: Is someone having Excel writing code without commate?
Posted: Fri Mar 10, 2017 5:00 pm
by Kukulkan
Thank you Michael, I will give it a try...
