<< xls_GetFont xls_link xls_GetWorksheetName >>

xls_link >> xls_link > xls_GetRange

xls_GetRange

Get range information.

Calling Sequence

strRange = xls_GetRange(rangeNew [, iRow, iCol])
[x, y, w, h] = xls_GetRange(rangeNew [, iRow, iCol])
strRange = xls_GetRange([iRow, iCol])
[x, y, w, h] = xls_GetRange([iRow, iCol])

Parameters

rangeNew

Origin cell.

Must be a cell, not a range.

if this parameter is not specificied, the current range was used.

iRow

Number of rows in the new range.

iCol

Number of columns in the new range.

Outputs

strRange

Return the range string ("A1:J5").

x, y, w, h

Return range information as integer [1,1,10,5] for ("A1:J5").

Description

Get range information.

Example

xls_NewExcel();
xls_AddWorkbook();

xls_GetRange()
[a,b,c,d] = xls_GetRange()

xls_GetRange(5,10)
[a,b,c,d] = xls_GetRange(5,10)

xls_GetRange("A1:J5")
[a,b,c,d] = xls_GetRange("A1:J5")

xls_GetRange("A1", 5, 10)
[a,b,c,d] = xls_GetRange("A1", 5, 10)

xls_SetSave(%t);
xls_Close();
xls_Quit();

See Also


Report an issue
<< xls_GetFont xls_link xls_GetWorksheetName >>