I'm trying to create a region and it gives me a Index error:
index:11 size: 10
var xlsTemplateData = Context.getFile("Template.xlsx", Constants.LOCATION_SCRIPT)
myWorkbook = Context.createExcelWorkbook(Context.getSelectedFile(), xlsTemplateData);
myWorkSheet = myWorkBook.getSheets()[0];
myWorkSheet.addRegion(3, 4, 5, 6);
Thank you
Hi Rahil,
the code you provided will work fine if you choose older .xls format for your template.
I have tested the new output formats, but as many others, without success. I am able to export raw data, but there are formatting issues (merge, colours...).
More information:
http://www.ariscommunity.com/users/ciskadj/2012-06-26-use-new-output
Best regards,
Martin