/

excelSetCurrentSheet

excelSetCurrentSheet

Owned by Radu Dumitriu (Deactivated)

Last updated: Nov 19, 2024 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

Related content

excelSetCurrentSheet

excelSetCurrentSheet

Power Suite Apps for Jira

More like this

excelSetCell

Power Suite Apps for Jira

More like this

excelAddRow

Power Suite Apps for Jira

More like this

excelAddSheet

Power Suite Apps for Jira

More like this

excelOpenWorkbook

excelOpenWorkbook

Power Suite Apps for Jira

More like this

excelReplaceRow

excelReplaceRow

Power Suite Apps for Jira

More like this