jeudi 21 avril 2022

Excel insert a Checkbox in RPGLE on iSeries (HSSF Scott Klement Java)

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:

enter image description here

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