Is there a way to get data from another excel workbook using office script

Ansh Vidyabhanu 40 Reputation points
2023-10-30T11:03:21.0933333+00:00

I have a workbook say 'Source.xlsx' and another workbook say 'Target.xlsx'.

Now I have a cell in 'Target.xlsx' which contains the link for 'Source.xlsx' now i want a button which gets the data from the workbook whose link was in that cell.

just a copy paste operation not a live link.

is this possible to do using a office script or an formula ?

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
604 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
913 questions
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,640 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yutao Huang - MSFT 701 Reputation points Microsoft Employee
    2023-10-30T18:26:17.76+00:00

    @Ansh Vidyabhanu Please take a look at this article and see if that does what you wanted to achieve: https://support.microsoft.com/en-us/office/create-workbook-links-c98d1803-dd75-4668-ac6a-d7cca2a9b95f#ID0EBF=Web.

    Please give it a try and let me know how it goes!