<< xls_AddWorkbook xls_link xls_CalculateRange >>

xls_link >> xls_link > xls_AddWorksheet

xls_AddWorksheet

Creates a new worksheet

Calling Sequence

sheets = xls_AddWorksheet()

Outputs

sheets

Return the new sheets count

Description

Creates a new worksheet. The new worksheet becomes the active sheet.

Example

xls_NewExcel();
xls_AddWorkbook();
for i=1:10
    x = xls_AddWorksheet();
    xls_SetWorksheet(x);
    xls_SetWorksheetName("My Worksheet " + string(i));
end
xls_SetSave(%t);
xls_Close();
xls_Quit();

See Also


Report an issue
<< xls_AddWorkbook xls_link xls_CalculateRange >>