I am trying to use the RowShift method in the HSSFSheet class, but I keep hitting a wall. the error is
...
Cause . . . . . : RPG procedure INSROWTEST in program POI36/INSROWTEST
received Java exception "java.lang.NoSuchMethodError:
org/apache/poi/hssf/usermodel/HSSFSheet.shiftRows(III)Lorg/apache/poi/h"
when calling method "shif" with signature "" in class
"org.apache.poi.hssf.usermodel.HSSFSheet". ...
Classpaths are correct and tested with the included example code provided in Scott's latest HSSF36 pack
I have defined the method
Code: Select all
D RowShift...
D PR O Class(*java
D : HSSF_SHEET_CLASS)
D ExtProc(*java
D : HSSF_SHEET_CLASS
D : 'ShiftRows')
D StartRow like(jint) value
D EndRow like(jint) value
D RowQty like(jint) value
D
Code: Select all
RowShift(Sheet: RowCount: RowAdd: RowQty);
// RowShift=new_XSSFRowshift(firstrow :lastRow :rowqty);
SSSheet_createRow(sheet: Rowcount);
hssf_save(book: IFSDIR + '/test1.xlsx');
Everything else is stock Hssf36 package
I understand this is probably a basic lack of understanding.