ARIS Community - We Love BPM

Insert row in Excel worksheet

nabira's picture
by maggiu pennarola in Reports & Macros posted on 2017-06-12

Hi Aris community,

I need create an excel workbook starting from a template and to modify only few data:

var sfile = Context.getFile(filename, Constants.LOCATION_SCRIPT);
if (sfile != null && sfile != undefined) {

    var p_output = Context.createExcelWorkbook ( Context.getSelectedFile() , sfile);

}

I need also to insert new rows in some position, shifting the next ones, but the method:

p_output.sheets[0].createRow (pos)

doesn't create a new row, it only returns me the existing row at position pos.

Is there any way to insert a new row (whithout using explicity org.apache.poi)?

Maggiù

 

1377 Views
0 Likes
0 Comments
Sorry there are no tags
There are no attachments