Update Cell of Speardsheet

[Rohullah]

hello

is exist any example for update cell of Spreadsheets in kendo ui?

thanks

[Stefan]

Hello, Rohullah,

This can be done using the value and values methods:

https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/value

https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/values

This is a runnable example showcasing it in action:

https://stackblitz.com/edit/kendo-react-spreadsheet-xwrksn?file=app%2Fmain.js

Regards,
Stefan
Progress Telerik

[Mohammad]

Spreadsheet = React.createRef();

const sheet = this.Spreadsheet.current.widgetInstance.activeSheet();

this.state.sheet.range(column + i).value(arrayValue[i]);
        this.state.sheet.range(column + i).background('#B5F78D');
        this.state.sheet.range(column + i).textAlign('center');

<Spreadsheet
              rows={1000}
              columns={5000}
              sheets={consts.sheets}
              ref={this.Spreadsheet}
            />