Is it possible to read data from another closed excel workbook using excel office script? Thanks Suji
1 Answers
This is only possible through Power Automation at this point. You'll have to run your script in a flow and feed the data from another workbook through a second script.
This article/video explains it all (video is bit grainy -- but you have full code samples here). Let me know if this solves your scenario.
https://github.com/sumurthy/officescripts-projects/tree/main/Event%20Cross%20Reference
Related