Update Cell of Speardsheet

3 posts, 0 answers
  1. Rohullah
    Rohullah avatar
    11 posts
    Member since:
    Feb 2018

    Posted 14 Jul Link to this post

    hello

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

    thanks

  2. Stefan
    Admin
    Stefan avatar
    2960 posts
  3. Mohammad
    Mohammad avatar
    17 posts
    Member since:
    Jan 2019

    Posted 01 Sep in reply to Rohullah Link to this post

    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}
                />
Back to Top