This is a migrated thread and some comments may be shown as answers.

Update Cell of Speardsheet

2 Answers 37 Views

Wrappers for React

This is a migrated thread and some comments may be shown as answers.

2 Answers, 1 is accepted

answered on 01 Sep 2020, 07:26 AM

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}

/>