i use the HSSF Excel-Tool from Scott Klement on iSeries.
i try to insert a checkbox in my Excel-Sheet with the POI API in RPGLE. But the methods to add Checkboxes aren't in the Scott Klement HSSF as an RPGLE Prototype.
Example:
I found these JavaCode to add Checkboxes:
XSSFVMLDrawing vmlDrawing = getVMLDrawing(sheet);
addCheckboxShapetype(vmlDrawing);
addCheckbox(vmlDrawing, 1, 0, 1, 0, 3, 0, 2, 0, "Checkbox 1", true);
addCheckbox(vmlDrawing, 1, 0, 2, 0, 3, 0, 3, 0, "Checkbox 2", false);
My Question: How can i use the addCheckbox Method in RPGLE to insert a Checkbox in my Excel-Sheet? How do I have to write the prototype in HSSF to use it on my RPGLE-Code? Is it possible?
Here for example the running RPG Code for add text in a Cell. Now i have to insert a Checkbox like this.
SS_TEXT( ROW: 0 : %TRIM(Titeltext) : text);
Prototype in HSSF:
D ss_text PR
D peRow like(SSRow)
D peCol 5I 0 value
D peString 1024A varying const
D peStyle like(SSCellStyle)
Aucun commentaire:
Enregistrer un commentaire