Excel Office Scripts

Ilavazhagan Yoganantham CNN 1 Reputation point
2021-09-21T05:49:02.55+00:00

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 Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,650 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. jeremy-msft 11 Reputation points Microsoft Employee
    2021-09-23T17:11:37.867+00:00
    0 comments No comments

  2. 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

    0 comments No comments