| Button handy |
|---|
| blank | true |
|---|
| color | #0052CC |
|---|
| name | Send Feedback |
|---|
| link | https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=excelSetCell+-+15484062 |
|---|
| width | auto |
|---|
|
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| heading | 0 |
|---|
| columnTypes | s,s,s,s |
|---|
| multiple | false |
|---|
| columnAttributes | style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold, |
|---|
| enableSorting | false |
|---|
|
Syntax | excelSetCell(workbookFID, value, [worksheet_name], cell_addr_or_x_y) | Package | excel | Alias | | Pkg Usage | setCell(workbookFID, value, [worksheet_name], cell_addr_or_x_y) |
|
...
| Code Block |
|---|
|
use "excel";
int fid = openWorkbook("snakes.xlsx");
setCurrentSheet(fid, "Venemous Snakes");
addRow(fid, 1);
setCell(fid, "Lawyer Snake", 1, 0);
insetCellsetCell(fid, "Cheatum Maximus", 1, 1);
closeWorkbook(fid); |
Result: A new row with data is added to the worksheet.
| Note |
|---|
Click here to download the workbook used in this example. |
...