2.2.4.46.72 Worksheet::SetBounds

SetBounds

Description

Set the begining and ending row indices for the specified columns in this Worksheet.

Syntax

BOOL SetBounds( int iR1 = 0, int iC1 = 0, int iR2 = -1, int iC2 = -1 )

Parameters

iR1

[input] Input begining row index (0 based)

iC1

[input] Input begining column index (0 based offset, default 0 is first column)

iR2

[input] Input ending row index (0 based, default -1 is last row)

iC2

[input] Input ending column index (0 based offset, default -1 is last column)

Return

Returns TRUE on success and FALSE on failure.

Examples

EX1

// usage
// wks_set_bound 1 0;// to clear worksheet
// wks_set_bound 3 200;// show rows from 3 to 200
void Worksheet_SetBounds_Ex1(int nBegin, int nEnd)
{
    Worksheet wks = Project.ActiveLayer();
    // convert LabTalk index into C index
    int nR1 = nBegin -1;
    int nR2 = nEnd -1;
    
    if( wks.SetBounds(nR1, 0, nR2) )
        printf("Success to set worksheet bounds!");
    else
        printf("Fail to set worksheet bounds!");
}

Remark

See Also

Worksheet::GetBounds, Worksheet::SetLowerBound, Worksheet::SetUpperBound, Worksheet::SetSize

Header to Include

origin.h