Please see this sample on how to combine data from multiple workbooks: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/combine-worksheets-into-single-workbook
Excel Office Scripts
Hi All,
I need an Office Script to connect two excel files. I need to Copy the data from one excel file (A:D) and Paste in another excel file (A:D). Is this Possible ? I was not able to get any script for two different excels from internet.
Thank you.
Regards,
Yoganantham Ilavazhagan
2 answers
Sort by: Most helpful
-
jeremy-msft 11 Reputation points Microsoft Employee
2021-09-23T17:11:37.867+00:00 -
Ilavazhagan Yoganantham CNN 1 Reputation point
2021-09-24T03:20:29.903+00:00 Hi,
Thanks a lot for coming back to me on this topic.
It satisfied 60% on my requirement, may be some changes is required in the code to update the values in the destination file on a particular sheet as this creates a new worksheet every time we run the flow instead of updating it.
If can help with that that would be great.
Regards,
Yoganantham Ilavazhagan