Hello everyone,
I was wondering if there is anyway to have a report output data to an existing .XLS file (chosen by the user) instead of always creating a new file (i.e. append output data to an existing spreadsheet on the users hard drive).
Any help with that would be greatly appreciated.
Hi Pedro,
Have a look at the following code:
var selExcelFile = Dialogs.getFilePath("",
"Excel Files (*.xls)|*.xls||",
"",
"Select Excel file to be openend",
0)
if(selExcelFile.length==1){
selExcelFile=selExcelFile[0];
var myWorkbook = Context.createExcelWorkbook(selExcelFile.getName(), selExcelFile.getData());
myWorkbook.write();
}
Regards,
Freddy
This is awesome Freddy. Thanks a million, you really helped me out.