<< xls_NewExcel xls_link xls_Open >>

xls_link >> xls_link > xls_OffsetRange

xls_OffsetRange

Add offset to a range.

Calling Sequence

newRange = xls_OffsetRange(range, row, col)

Parameters

range

Range to add offset.

row

Row offset.

col

Col offset.

Outputs

newRange

Return new string range ("C3:D6").

Description

Add offset to a range.

Example

xls_NewExcel();
xls_AddWorkbook();
xls_SetVisible();
newRange = xls_OffsetRange("A1:B4", 2, 3)
xls_SelectRange(newRange);
xls_SetData('New range');
sleep(1000);
xls_SetSave(%t);
xls_Close();
xls_Quit();

See Also


Report an issue
<< xls_NewExcel xls_link xls_Open >>