Office 2013 Javascript API Get Sheet Name of Selection

Question

I'm working on a sidebar app, which could have bindings on multiple sheets on an Excel document. I want to name those bindings based on the sheet that the user's selection is on, to only interact with data on the current sheet. Is there a way to get the current sheet? Or the sheet of the selection? Or the sheet of a binding? Thanks!

Answer 1

Hi Andy,

I'm afraid it is impossible at present since the worksheet is not in Office JavaScript Object Model.

The thread below provides a workaround by binding each sheet, it's not perfect, I have to say, but It seems the only workaround we could figure out now.

How to get the sheet name or number from document selection changed event in apps for office?

I would suggest you submit feedback from Customer Feedback for the Office Developer
Platform.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Hi George, thanks for the reply. The methods in your link don't work, unfortunately. They require a template, but I'm trying to write an app.