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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

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                                     :*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