Forum

RPG to use POI via ...
 
Notifications
Clear all

RPG to use POI via Scott Klement's Prototypes to Read XLTX by Ernesto

 
Adsero Optima
Member Admin

I have a Command that uses Scott Klement's HSSFR4 to creates Excels... XLS. We use it to be able to create Excels with formatted columns. We are using POI 3.6

Updated the process to be able to Read a XLT Template and Create XLS via the following:

D openTemplate PR O EXTPROC(*JAVA : HSSF_WORKBOOK_CLASS
D :*CONSTRUCTOR)
D CLASS(*JAVA : HSSF_WORKBOOK_CLASS)
D parm O CLASS(*JAVA
D :'java.io.InputStream')
D parm N value

D wb s like(SSWorkbook)

// And in the Program

wb = openTemplate(inFile_InputStream : True );

the above works fine ... and then the Excel is saved via:

SS_save(wb: IFSFile);

My Question: I am trying to Create an XLSX (that I am able to create w/o template); but I want to use XLTX, but Not Luck.
I am able to read an XLSX as Template; but I lose the Column Formatting.

Anyone has been able to use POI and Scott Klement's process to read XLTX ?

Thanks ..

Ernesto

This topic was modified 12 months ago by Adsero Optima
Quote
Topic starter Posted : 26/01/2021 11:58 am