8.1.26.9 Worksheet::GetData

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.

Contents

Description

Get data from a specified worksheet

Syntax

GetData(nRowStart = 0, nColStart = 0, nRowEnd = -1, nColEnd = -1, format = ARRAY2D_VARIANT)

Parameters

nRowStart
beginning data row, 0 offset. Default is zero
nColStart
beginning data column, 0 offset. Default is zero.
nRowEnd
ending data row, -1 to last row.
nColEnd
ending data column, -1 to last column
format
Options from ARRAYDATAFORMAT
	ARRAY2D_VARIANT,
	ARRAY1D_NUMERIC,
	ARRAY2D_NUMERIC,
	ARRAY2D_TEXT,
	ARRAY2D_TEXT_FULL_PRECISION,

	ARRAY1D_VARIANT,
	ARRAY1D_TEXT,
	ARRAY1D_TEXT_FULL_PRECISION,

	ARRAY1D_STR,
	ARRAY2D_STR,

	ARRAY1D_STR_FULL_PRECISION,
	ARRAY2D_STR_FULL_PRECISION,

	ARRAY1D2D_MASK_BITS,
	ARRAY1D_DICTIONARY,
	ARRAY1D2D_TRANSPOSED,


Return

A two-dimensional array containing the data from the worksheet.

Examples

import PyOrigin
wks=PyOrigin.FindWorksheet('[Book1]Sheet1')
data = wks.GetData(0, 0, -1, -1, PyOrigin.ARRAY2D_VARIANT | PyOrigin.ARRAY1D_DICTIONARY)
print(data)

Worksheet::SetData