<< xls_AddWorksheet xls_link xls_CallMacro >>

xls_link >> xls_link > xls_CalculateRange

xls_CalculateRange

calculate a excel range

Calling Sequence

Range = xls_CalculateRange(FirstCell, Dimensions)

Parameters

FirstCell

a string first cell position

Dimensions

a vector of 2 dimensions of matrix to calculate range

Range

a string: range calculated

Description

Calculates a excel range with a startup cell position and size of a matrix.

Examples

xls_NewExcel();
xls_AddWorkbook();
xls_CalculateRange('A1',[1 1])
xls_CalculateRange('A1',[1 2])
xls_CalculateRange('A1',[2 2])
ver_excel_num = strtod(xls_GetExcelVersion());
if ver_excel_num > 11 then
max_cell_xls = "XFD1048576";
else
max_cell_xls = "IV65536";
end
xls_Close();
xls_Quit();

See Also


Report an issue
<< xls_AddWorksheet xls_link xls_CallMacro >>