Activate worksheet on created workbook in Excel JavaScript API

Question

It's possible to create and open new workbook using Excel JavaScript API using Excel.createWorkbook()

Is there a way to activate a specific worksheet on this newly created workbook? The current context belongs to the original workbook that currently exists in the runtime.

Perhaps you might have better luck using something else other than office-js, like Sheets.JS? — FreeSoftwareServers
– FreeSoftwareServers, Commented Oct 27, 2023 at 23:26

Rick Kirkham · Accepted Answer · 2023-10-20 23:54:41Z

1

That can't be done. An add-in running in the context of one workbook cannot call out to another one.

answered Oct 20, 2023 at 23:54

Rick Kirkham

9,9172 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Activate worksheet on created workbook in Excel JavaScript API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related