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.

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples

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)