Forum

RPG to use POI via ...
 
Notifications
Clear all

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

1 Posts
1 Users
0 Reactions
438 Views
Adsero Optima
Posts: 35
Member Admin
Topic starter
 

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 4 years ago by Adsero Optima
 
Posted : 26/01/2021 11:58 am