libxlsxwriter

[the.weavster]

I understand PB 6.10 is going to be a feature release and so I'd like to propose the addition of libxlsxwriter.

Databases need reports and I think this would be a good step in that direction.

[Little John]

We know that XLS and XLSX are proprietary file formats by Microsoft.
Wouldn't it be better for PureBasic to support spreadsheets according to the Open Document standard? Just an idea.

[the.weavster]

We know that XLS and XLSX are proprietary file formats by Microsoft.

The XLSX format was developed by Microsoft but I believe it's now an open standard ( ECMA-376, ISO/IEC 29500 ) and covered by Microsoft's Open Specification Promise.

Trying to come up with something as functional as XLSXWriter for the ODF format would be a lot more work than incorporating an existing, well tested library.

[the.weavster]

Bump
I still think this would be a cool feature for those of us that do business applications

The library is written in ANSI C, the license is FreeBSD and the only dependency is zlib.

[Caronte3D]

+1

[Fred]

This one is too specific for PB IMHO, but it seems very easy to wrap. You just need to build the lib with cmake and do the import files.

[Justin]

This can be useful, so i compiled the static libs for mac, win and linux.

I imported a few functions to test, it works on the 3 platfroms creating an standalone executable. I don't have the time now to translate all the headers but it should be simple.

To install it simply copy the corresponding static libs for the OS to the PureLibraries\UserLibraries folder in every purebasic installation.
Or compile them by yourself, the libs to copy are: libxlsxwriter, libminzip and libz

Run the example xlsxwriter_test.pb, this will create a basic xlsx file.
Only for 64 bit for now.

Project at github:
https://github.com/omegakode/PBXlsxWriter

[jack]

I had a look at the libxlsxwriter project, the project builds quickly and without any warnings or errors using msys2
but some of the headers are a bit complex

[Justin]

After looking at it the most complex part will be the macros from sys/queue.h and sys/tree.h, but definitely doable. The rest are normal structs and enums.

[the.weavster]

To install it simply copy the corresponding static libs for the OS to the PureLibraries\UserLibraries folder in every purebasic installation.
Or compile them by yourself, the libs to copy are: libxlsxwriter, libminzip and libz

Run the example xlsxwriter_test.pb, this will create a basic xlsx file.
Only for 64 bit for now.

Project at github:
https://github.com/omegakode/PBXlsxWriter

Thanks, Justin
This is really helpful.

[Quin]

This can be useful, so i compiled the static libs for mac, win and linux.

I imported a few functions to test, it works on the 3 platfroms creating an standalone executable. I don't have the time now to translate all the headers but it should be simple.

To install it simply copy the corresponding static libs for the OS to the PureLibraries\UserLibraries folder in every purebasic installation.
Or compile them by yourself, the libs to copy are: libxlsxwriter, libminzip and libz

Run the example xlsxwriter_test.pb, this will create a basic xlsx file.
Only for 64 bit for now.

Project at github:
https://github.com/omegakode/PBXlsxWriter

Managed to get it to work on Windows 10 21H2 IoT. Well done!