question

IlavazhaganYogananthamCNN-4171 avatar image
0 Votes"
IlavazhaganYogananthamCNN-4171 asked IlavazhaganYogananthamCNN-4171 answered

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

office-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

jeremy-msft avatar image
0 Votes"
jeremy-msft answered

Please see this sample on how to combine data from multiple workbooks: https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/combine-worksheets-into-single-workbook

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IlavazhaganYogananthamCNN-4171 avatar image
0 Votes"
IlavazhaganYogananthamCNN-4171 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.