Versions Compared

Old Version 5

changes.mady.by.user Jonathan Muse

Saved on

compared with

New Version Current

changes.mady.by.user Jonathan Muse

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Button handy
blanktrue
color#0052CC
nameSend Feedback
linkhttps://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=excelSetCell+-+15484062
widthauto

Table plus
applyColStyleToCelltrue
heading0
columnTypess,s,s,s
multiplefalse
columnAttributesstyle="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSortingfalse

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
languagejs
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);

...