scottklement.com

Hello Scott, I have changed the code and it is simple program with 1 row in XLS, no sql no files. only thing is you can use the below call command with parameters call *libl/RVATXLSK parm('240201' '240229' 'scott@scott.com') H DFTACTGRP(*NO) H OPTION(*SRCSTMT: *NODEBUGIO: *NOSHOWCPY) H THREAD(*SERIA...

Hi Scott,
I am still having issue in € symbol in XLS (HSSF)

Hi Scott

Sorry it was my mistake completely, initially I have used the new_stringC() that is when i have received ¬112.23.
then later i changed it to new_string() to check if there is any change. did not work.
I completely forgot to change back when i copied the full code.

Hi scott please find the below full code H DFTACTGRP(*NO) H OPTION(*SRCSTMT: *NODEBUGIO: *NOSHOWCPY) H THREAD(*SERIALIZE) H BNDDIR('HSSF') *-------------------------------------------------------------------- D/copy qsysinc/qrpglesrc,jni D/copy *libl/qrpglesrc,HSSF_H * * D RVATXLSK PR ExtPgm('RVATXL...

Hello Scott Thank you, i have used the same logic you provided (unicode), but in XLS instead of €112.23 i received this ¬112.23. below is the code D new_StringC PR like(jString) D EXTPROC(*JAVA D :'java.lang.String' D :*CONSTRUCTOR) D create_from 16383c VARYING const D DOLLAR C U'0024' D EURO C U'20...

Hi Scott The code works for the "$" but for "€" it is not working. when i add "€" in AS400 it is changing to "?". TempStr = new_String('[$€-x-euro2] #,##0.00'); this is not working and once i save or file the program € is changing to ? and excel also same ? be...

Hi Scott i have 2 fields in xls one of it should be €20.00 and other field $50.00 I am unable to use Euro symbol in AS400 but i have tried the same for $ but did not work. what i need is both € and $ in xls. Please find the below code from HSSFR4 D Currusd s like(HSSFCellStyle) D CreateCellStyles......

I am using HSSF and creating new book, new sheet and new row i am able to write data from file but what i need is format one Colum with currency "$ or euro" how can i do using HSSF. please see the below example Invoice# Commodity Country of Destination Country of Origin Mode of Transportay...