Skip to main content

setValue()

Description​

Sets a value for a cell

info

The method allows setting the same/repeated value(s) for the specified cells. In case you want to add different values into spreadsheet cells, you'd better use the parse() method.

Usage​

setValue(cell: string, value: string | number | array): void;

Parameters​

  • cell - (required) the id(s) of a cell(s) or a range of cells
  • value - (required) the value(s) to be set for cells

Example​

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);

// setting value for one cell
spreadsheet.setValue("A1",5);

// setting the same value for a range of cells
spreadsheet.setValue("A1:D1",5);

// setting the same value for different cells
spreadsheet.setValue("B6,A1:D1",5);

// setting values from an array for cells in a range alternately
spreadsheet.setValue("A1:D1",[1,2,3]);

Related sample: Spreadsheet. Initialization with multiple sheets

info

Starting with v4.1, the reference to a cell or range of cells can be specified in the following format:

spreadsheet.setValue("sheet1!A1",5);

where sheet1 is the name of the tab.

In case the name of the tab isn't specified, the method will set the value(s) for the cell(s) of the active tab.