Hi,

I developed a library that allows you to create a file in xlsx format.
This is a first version that is functional but does not include style sheets.
It is quite possible to use it on all versions provided you modify the creation part of a compressed file. I have to use commands specific to ERP LN.
The archive contains the source of the library and a 3GL program that shows the use of the different functions.

JPH

Hi,

I developed a library that allows you to create a file in xlsx format.
This is a first version that is functional but does not include style sheets.
It is quite possible to use it on all versions provided you modify the creation part of a compressed file. I have to use commands specific to ERP LN.
The archive contains the source of the library and a 3GL program that shows the use of the different functions.

JPH

Nice to see a native solution.
May be the thread should be in Code & Utilities SIG.

Regards,

We can always move it to the code and utilities forum. When get a chance I will have to look at the code.

Hi,

I developed a library that allows you to create a file in xlsx format.
This is a first version that is functional but does not include style sheets.
It is quite possible to use it on all versions provided you modify the creation part of a compressed file. I have to use commands specific to ERP LN.
The archive contains the source of the library and a 3GL program that shows the use of the different functions.

JPH

How to use this in Baan 4c4?

The attached zip file appears to miss zgcomdll0002 as it is one of the libraries being used. I got compilation errors for zgcomdll0001 for data types such as bctls.styp.string. I tried to use this library in LN 10.2. Please advise if any recommendations

Sir, very big thanks for your contribution. It is a great script. I replaced the domain with ttadv.type and every thing worked including your 3 GL.

Sir, your code base was very much useful to get the idea. However it was not directly helpful to me as it assumes me to know all the columns count in the very beginning of the library call. My requirement algorithm is as shown below
1. open work sheet
2. fill A1, B1, C1, D1 ....until a specific condition meet
3. switch to next row
4. again fill A1, B1, C1, D1 ....until a specific condition meet
and the flow continues
Hence, I wrote the dll as per my convenience and attached a sample 3GL to demonstrate how to use it.