Excel Office Scripts

Question

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

Answer 1

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

Answer 2

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