Libxlsxwriter for Clarion


#1

Create xlsx (Excel) files directly, without Excel!
Wrapper based on libxlsxwriter С library (https://libxlsxwriter.github.io/)

Requirements: C6 or higher (older versions not tested)

Free (donate)


#2

I have a wrapper class and template set for using this library.


#3

What license is this released under?


#4

Use LibXLSWriter with Clarion 6-7 months.
The rate of export of about 10,000 cells / sec.
Completely open source, no black boxes.
The project is steadily evolving and expanding.
There are some minor functionality limitations
in the formation of XLSX files relating to the underlying DLL.
A very interesting project !


#5

Thanks Rafael,

It would be intresting to merge tokens from a xlsx template, representing tps fields, to the xml before zipping to an xlsx


#6

You can do that with evalute function


#7

Think it’s more difficult.

In asci (xml) it’s easy to merge fields from a (tps) database but it should work with a template format for repeating groups (ie order lines) and pagebreaks as input.


#8

Updated to 1.0
Outlines, error bars, lots of fixes
98% of original lib functionality is supported


#9

Thank you
regards
Victor M.


#10

I use this product from Klarisoft from http://www.klarisoft.com/KSNews_190.htm.

Klarisoft wrote the clarion template, but uses a COM free DLL from www.libxl.com

This is fast and very happy with the performance so far.


#11

Thanks Mathew,

LibXL not only creates xls/xlsx files but can also read and modify them

Leonid


#12

Does LibXL support charts?


#13

Hi RaFael,

I know libxlsxwriter cannot read an xlsx, but it’s zipped ascii.
Do you know how to use it as a reporting/BI tool in clarion.
See screenshot for example


#14

Updated to 1.1
Chartsheets, some fixes