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
We've encountered an issue exporting this macro. Please try exporting this page again later.