calculate a excel range
Range = xls_CalculateRange(FirstCell, Dimensions)
a string first cell position
a vector of 2 dimensions of matrix to calculate range
a string: range calculated
Calculates a excel range with a startup cell position and size of a matrix.
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(); | ![]() | ![]() |