excelSetCurrentSheet

Owned by Radu Dumitriu (Deactivated)

Last updated: yesterday at 6:03 pm by Jonathan Muse

1 min read

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