You’re offline. This is a read only version of the page.
Announcements
213
Hi,
I got a short question.
Let's assume we have an excel file that consists of a single worksheet and stored in the SP library.
How to get the table from the worksheet and add it to another workbook as a new worksheet?
Important Information
I have tried using excel actions such as list rows in a table, add rows etc. But it takes a huge amount of time when the data has 2000rows in it.
Additionally, Has anyone used Recorder or Office Script for such a case?
Thanks!
Hey @Serbay -
Regarding the Office Scripts solution, I think you may need to write two scripts and have their respective flow actions for that - one to read the data from the first workbook, another to write the data to the second workbook.
Wondering if this post could help: https://powerusers.microsoft.com/t5/Using-Flows/Trying-to-use-Office-Scripts-and-Flow-to-copy-from-one-workbook/m-p/691971#M17867
-Yutao
Share
Report
All responses (
Answers (
