/

excelSetCell

excelSetCell

Owned by Jonathan Muse

Last updated: Nov 20, 2024

1 min read

Description

Updates the value of the specified cell in the open workbook.

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);
setCell(fid, "Lawyer Snake", 1, 0);
setCell(fid, "Cheatum Maximus", 1, 1);
closeWorkbook(fid);

Result: A new row with data is added to the worksheet.

Click here to download the workbook used in this example.

See also

Related content

excelAddRow

Power Suite Apps for Jira

More like this

excelOpenWorkbook

excelOpenWorkbook

Power Suite Apps for Jira

More like this

SIL Excel User guide

SIL Excel User guide

Power Suite Apps for Jira

Read with this

excelSetCurrentSheet

excelSetCurrentSheet

Power Scripts for Jira Cloud

More like this

SIL Excel Connector

SIL Excel Connector

Power Suite Apps for Jira

Read with this

excelSetCurrentSheet

excelSetCurrentSheet

Power Suite Apps for Jira

More like this