Read data from another excel workbook using office script

Question

Is it possible to read data from another closed excel workbook using excel office script? Thanks Suji

Answer 1

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