Skip to Content (Press Enter)
2018-12-14 09-32-03
Tiago Lopes
327Views
4Comments
Solved
[Excel Package] [Excel Package] Merge excel files
Question
Forge
excel-package
Web icon
Excel Package (O11)
Forge asset by Alfaro

Hi.. Is it possible to copy a Worksheet of a Workbook to a different Workbook with this component ?

0
0
27 May 2019
Copy Link
2025-02-22 18-27-01
Alfaro
 
MVP
Solution

Hi Tiago,

It is possible to copy a Worksheet of a Workbook to a different Workbook, by using the Workbook_AddCopyWorksheet action.

Here is a simple code example of using that action, to "merge" two RecorListToExcel actions into one output file.

Hope this helps. Any question, please feel free to reply.

Thank you.

CA

2
0
28 May 2019
Copy Link
UserImage.jpg
Vishnu shankar

Hi @Alfaro ,

I couldn't copy the worksheet using the Workbook_AddCopyWorksheet action from the Excel_Package; I'm getting this error: "Object reference not set to an instance of an object."

Actually, the Workbook_AddCopyWorksheet action is for copying the worksheet or pasting the worksheet into another workbook.

I can't find any actions for inserting the copied worksheet in the Excel_Package component.

I need your guidance on this.

If possible, could you please share a sample demo OML for this.

Waiting for your response.

Thanks & Regards,

Vishnu Shankar

0
0
18 Apr 2025
Copy Link
2018-12-14 09-32-03
Tiago Lopes

Thank you Carlos.. 

It worked out

0
0
28 May 2019
Copy Link
UserImage.jpg
Thinh Nguyen

Thanks ! create one  file  multiple  sheet 

0
0
21 Feb 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.