Append data to existing Excel spreadsheet?

Last activity on October 1, 2023 - 11:21 21.4k Views 3 Replies Reports & Macros

Pedro Peregrino on July 19, 2015

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.

Bookmark

Notify Moderator

3 Replies

Freddy Barkhuizen on July 20, 2015 - 07:22

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

or register to reply.

Notify Moderator

Pedro Peregrino Author on July 21, 2015 - 21:41 as Reply to Freddy Barkhuizen

This is awesome Freddy. Thanks a million, you really helped me out.

or register to reply.

Notify Moderator

Freddy Barkhuizen on July 22, 2015 - 06:46

Pleasure Pedro, glad I could help.

or register to reply.

Notify Moderator