/
excelSetCurrentSheet
excelSetCurrentSheet
Description
Specifies the current sheet by name or index that subsequent processes should use.
Parameters
Return Type
Boolean
Returns true if the operation was successful, false otherwise.
Example
Add a new row and data to an existing workbook.
use "excel";
int fid = openWorkbook("snakes.xlsx");
setCurrentSheet(fid, "Venemous Snakes");
addRow(fid, 1);
setCurrentSheet(fid, "Non-Venemous Snakes");
addRow(fid, 1);
closeWorkbook(fid);
Result: A new row is first added to the Venemous Snake sheet then a new row is added to the Non-Venemous Snake sheet.
Click here to download the workbook used in this example.
See also
Related content
excelSetCurrentSheet
excelSetCurrentSheet
More like this
excelSetCell
excelSetCell
More like this
excelAddRow
excelAddRow
More like this
excelAddSheet
excelAddSheet
More like this
excelOpenWorkbook
excelOpenWorkbook
More like this
excelReplaceRow
excelReplaceRow
More like this