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ù
Francois Du Toit on
Hi,
As far as I know inserting rows is not possible, removing rows are. I added example 10 rows on my template, then remove the ones not in use. Not ideal, but does provide a work-around...
Rgs,
Francois