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 ...

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 ...

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 ...

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 ? before the number example instead of €10 ...

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 Transportayion ...