RPG to use POI via Scott Klement's Prototypes to Read XLTX by Ernesto
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 CLASS(*JAVA : HSSF_WORKBOOK_CLASS)
D parm O CLASS(*JAVA
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:
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 ?