Forum Discussion
Use Script to Migrate Excel Date
My assigned task is to develope an automatic and recurring way to copy multiple rows of data - that are not formatted as a table, from one Excel workbook and save it in another as a table.
Can I achieve this task using Excel Scripts and Power Automate, without having to physically open and close the source workbook - everything should happen without manual assistance or intervention, is this possible.
Thank You, both, for your assistance.
That's an idea.
1) Using any file create ExcelScript which combines data within workbook as required
2) In Power Automate create the flow which is triggered when new file is appeared in SharePoint folder or like, which trigger is more close to your business process. Next flow steps are
3) Delete existing master file
4) Copy that new file (we shall have it's ID on previous step) on another folder a master file
5) Run prepared script on that file
6) Remove appeared new file
If master file shall be updated with new information, not replaced, perhaps create two ExcelScripts, one as above and another one updates excel with csv text.
Again, above is only idea, evil could be in details.
- More important, is it doable.
The rest back and forth implies to me that it may not be possible to achieve.
I trying to get confirmation the task can be accomplished and the tools that can be used to accomplish it.
Thank you, That's relatively big project, I could try to answer on concrete questions but not to build everything from scratch.
- move the data in the attached (range A5:K10) to another Excel workbook
As discussed before,It is not easy to achieve your goal.
Why not try other method rather than Excel office Script?
Because ypu mentioned SharePoint,I guess you need a multiple users solution instead of only yourself.
In another words,your need may be relative to co-work. - Is this something either you or NikolinoDE can help me build?
I do have this challenge in front of me that I lack the knowledge and abillity to complete.
However, I don't want to raley that it can't done if, indeed, it can be done.
