8.2.12 FindMatrixSheet

It is recommended that you switch to the originpro package. PyOrigin is primarily for users who need to work with Origin version prior to 2021.

Description

Find a matrix sheet by name.

Syntax

FindMatrixSheet(name)

Parameters

name

The range string of the Origin matrix sheet to be found. The range string contains the workbook name between square brackets followed by the sheet name:

[<bookName>]<sheetName>

The following special notations are also supported:

1. Empty string -- this means the active sheet from the active book
2. Book name only -- like "Book1", will get the active sheet from named book
3. Sheet name only with ! at the end -- like "Sheet2!", will get the named sheet from the active book

Return

The MatrixSheet

Examples

EX1

import PyOrigin
MSheet=PyOrigin.FindMatrixSheet('[MBook1]Sheet1')
nCol=MSheet.GetColCount()
nRow=MSheet.GetRowCount()
print('The dimension of the matrixSheet is %s*%s' % (nCol,nRow))