To procedure . . . . . . . : HSSF_SAVE Statement . . . . . . . . . : 8100 Message . . . . : Java exception received when calling Java method. Cause . . . . . : RPG procedure HSSF_SAVE in program XLV5R1/HSSFR4 receive Java exception "java.io.FileNotFoundException:" when calling method "<init with signature "(Ljava.lang.String;)V" in class "java.io.FileOutputStream"
This is usually occurring when the XLSPATH keyword is not submitted correctly.
When using a specified XLSPATH the format is as below:
XLSPATH('/myfolder/myfile.xls')
I was getting this error even tho I was calling with a valid XLSPATH (command: XLCRT FILE(L#JWROTH/ABCFILE) XLSPATH('/home/jwrothw/abcfile.xls') )
I debuggged the process and found that var XLSFilename was blank at the point where the spreadsheet file was being created.
It doesn't appear that XLSFilename gets set unless XLSPath = *blanks or *DEFAULT - see XLCRTR, starting at line 434.
Once I plugged in a value for XLSFilename in debugger, the process worked fine.
BTW, I'm working with the V5R1 version; the V5R3 may be different.
I still get this error for both version, even XLSPath = *DEFAULT or having correct value. When do we have an update version? Thanks!
the update to address that issue should be available on all mirrors now. Please let me know if you still have this issue.
Where can we find the update?
I looked everwhere on this site but didn't find it.
The update is inside the latest file release for V5R1 and V5R3, which can be downloaded from the main page. http://sourceforge.net/projects/iseriestoexcel
Log in to post a comment.
To procedure . . . . . . . :
HSSF_SAVE
Statement . . . . . . . . . :
8100
Message . . . . : Java exception received when calling
Java method.
Cause . . . . . : RPG procedure HSSF_SAVE in
program XLV5R1/HSSFR4 receive
Java exception "java.io.FileNotFoundException:" when
calling method "<init
with signature "(Ljava.lang.String;)V" in
class "java.io.FileOutputStream"
This is usually occurring when the XLSPATH keyword is not submitted correctly.
When using a specified XLSPATH the format is as below:
XLSPATH('/myfolder/myfile.xls')
I was getting this error even tho I was calling with a valid XLSPATH (command:
XLCRT FILE(L#JWROTH/ABCFILE)
XLSPATH('/home/jwrothw/abcfile.xls') )
I debuggged the process and found that var XLSFilename was blank at the point where the spreadsheet file was being created.
It doesn't appear that XLSFilename gets set unless XLSPath = *blanks or *DEFAULT - see XLCRTR, starting at line 434.
Once I plugged in a value for XLSFilename in debugger, the process worked fine.
BTW, I'm working with the V5R1 version; the V5R3 may be different.
I still get this error for both version, even XLSPath = *DEFAULT or having correct value. When do we have an update version? Thanks!
the update to address that issue should be available on all mirrors now. Please let me know if you still have this issue.
Where can we find the update?
I looked everwhere on this site but didn't find it.
The update is inside the latest file release for
V5R1 and V5R3, which can be downloaded
from the main page.
http://sourceforge.net/projects/iseriestoexcel