1.1.14 OA_FindWorksheet


Description

Get a Worksheet object from a book sheet range string, such as [Book1]Sheet2.

Connector Pane

OA FindWorksheet CP.jpg

Controls and Indicators

CI ref c.jpg Origin.IOApplication
CI string c.jpg Name is a book sheet range string, such as "[Book1]Sheet1". You can use an empty string to get the active sheet from the active book, but if no active book or active book is not a workbook, then the output refnum for Origin.Worksheet will be invalid.
The following variations are also supported:

Book1 find the active sheet from book1
Sheet2! find Sheet2 from the active book

CI err c.jpg Error In contains error information that occur before this VI or function runs.
CI ref i.jpg Origin.IOApplication.Out is a reference to Origin.ApplicationSI.
CI ref i.jpg Origin.Worksheet is a reference to Origin.Worksheet
CI err i.jpg Error Out contains error information.
Note: This VI is available since Origin 8 SR2.