Is GetActiveSheet the only way to get the Worksheet object?

Integration questions/issues
Post Reply
ethan
Posts: 2
Joined: Thu Jul 13, 2017 4:15 pm

Is GetActiveSheet the only way to get the Worksheet object?

Post by ethan » Fri Jul 14, 2017 10:30 am

Is there any method of creating or getting a specific worksheet object other than Api.GetActiveSheet()?

Maxim
Posts: 2017
Joined: Tue Oct 11, 2016 2:34 pm

Re: Is GetActiveSheet the only way to get the Worksheet obje

Post by Maxim » Mon Jul 17, 2017 8:48 am

Hello ethan!
There is no another way but we plan to add next release a method to get via name or index.

kdarn
Posts: 1
Joined: Tue Oct 15, 2019 6:43 am

Re: Is GetActiveSheet the only way to get the Worksheet object?

Post by kdarn » Tue Oct 15, 2019 6:56 am

Hi everybody, hi maxim,
has there been any progress on this issue in the meamwhile?
I'm looking for a "external file cell referencing" method.
As far as I know, OpenOffice doesn't provide such a referencing method within the spreadsheet editor (something like '[ExampleSpreadsheet.xlsx]Sheet1'!A1 in MS Office).
Is there any macro workaround so that I can insert data from another spreadsheet in the cloud (nextcloud)?

Post Reply