Libxlsxwriter for Clarion

RaFaeL · February 1, 2018, 9:52pm

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)

pkonyk · February 2, 2018, 1:31am

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

http://ikonyk.ca/clarion/

Ben · February 3, 2018, 2:33am

What license is this released under?

Genricke · February 3, 2018, 6:07am

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 !

Dirk · February 12, 2018, 3:02pm

Thanks Rafael,

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

jarodav1 · February 13, 2018, 4:37am

You can do that with evalute function

Dirk · February 13, 2018, 8:31am

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.

RaFaeL · February 15, 2018, 9:53am

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

jarodav1 · February 16, 2018, 12:09am

Thank you
regards
Victor M.

Mathew · February 16, 2018, 11:38am

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.

lchudakov · February 16, 2018, 1:40pm

Thanks Mathew,

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

Leonid

RaFaeL · February 16, 2018, 2:41pm

Does LibXL support charts?

Dirk · February 20, 2018, 4:40pm

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

RaFaeL · October 2, 2018, 5:56pm

Updated to 1.1
Chartsheets, some fixes

RexCalifornia · December 26, 2018, 7:55pm

Thanks RaFael . This is awesome product.

pblero · April 4, 2019, 12:42pm

Hello Leonid,

I’m working with Clarion 6.3 and I’m very interesting by your product.

If I understand, it is possible to open and modify both xls and xlsx files.

I especially need to make replacements in those files.

Is it possible?

Is it compatible with Office 2016?

Do you have a similar product for doc and docx files?

Thank you in advance.

Kind regards.

Paul

lchudakov · April 4, 2019, 1:05pm

Hi Paul,

Yes both creating and modifying is supported. Compatible with Office 2016 and Clarion 6.3
For doc/docx files you can try TX Text control (Pro version)
http://klarisoft.com/KSNews_idx21.htm

Leonid

pblero · April 4, 2019, 1:33pm

Hello,

Thank you for answering so fast.

I will look at this products carefully.

Kind regards,

Paul

Nyq · May 16, 2019, 8:53am

@RaFaeL: Does Libslsxwriter for Clarion support data validation and cells with a drop-down list?

RaFaeL · May 16, 2019, 9:31am

It’s supported by lib but not by wrapper for now (may be in future…). You’re need it?