excelSetCell

Owned by Jonathan Muse

Last updated: Oct 11, 2024 by Shane Smith

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