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.