I want to copy the Excel sheet from one workbook to another workbook. I know there is one action for this named Workbook_AddCopyWorksheet, but I don't know how to use this in logic.
Can anyone guide me on how to implement this logic using the Excel_Package component.
If possible, please share a sample OML.
Thanks & Regards,
Vishnu Shankar
Hi @Vishnu shankar,
You can check out this forum discussion—it provides helpful insights and a potential solution.
https://www.outsystems.com/forums/discussion/48363/excel-package-excel-package-merge-excel-files/
Hope this helps
Thanks
Hi @Aditi Saraswat ,
Thanks for your response, but I already visited that page. I can't find any solution there, and I posted a comment on that page already regarding this issue.
You can refer to this discussion https://www.outsystems.com/forums/discussion/74506/excel-package-problem-using-excel-package-with-the-office-365/
Hope this shows you how to use Workbook_AddCopyWorksheet in the logic.
I am attaching the OML.
Hope this resolve your issue.
Hi Vishnu,
There was a similiar post recently that will help you. The component in that post is Advanced Excel but the logic will be the same as in Excel Package.
Hi @Vishnu shankar
Considering the issue that you have mentioned, you can try an approach where you can build the destination workbook sheet manually.
If your sheet contains only data (no formulas, no formatting):