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.

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