OOO13377771610 great questions—
- Can the script in one workbook use this apparently-special API to access another workbook in the same tenant ? (as Power Automate does)
- Yes—scripts are actually workbook-agnostic at the moment. You can use any script on any workbook, and you can create flows involving multiple workbooks. You can also pass data between scripts and workbooks by including parameters and return values in your scripts.
- Does running the script directly or via-power-automate willl lock the file properties metadata from being edited? (as Power automate does)
- That's actually a great question—as far as I know, a file's metadata shouldn't be locked while a script is running. Scripts run as if the user who owns them were directly performing the actions manually.
- Edit: I've confirmed that files' metadata are no longer locked for editing in the Excel Online Business connector—this applies to both Office Scripts' "Run script" action and all other Excel connector actions.