Skip to content

spreadsheet_setvalue_method.md

Latest commit

 

History

History
59 lines (40 loc) · 1.67 KB

spreadsheet_setvalue_method.md

File metadata and controls

59 lines (40 loc) · 1.67 KB
sidebar_label setValue()
title setValue method
description You can learn about the setValue method in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet.

setValue()

Description

@short: 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 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. :::