Function: setCellValue()

function setCellValue(
   worksheet: Worksheet, 
   row: number, 
   col: number, 
   value: any): void;

Defined in: src/excel/excel.tsx:853

Set the value of a cell.

Parameters

Parameter	Type	Description
worksheet	Worksheet	The ExcelJS worksheet.
row	number	The 1-based row index.
col	number	The 1-based column index.
value	any	The value to write.

Returns

void

Example

setCellValue(worksheet, 2, 4, 'Approved');
setCellValue(worksheet, 1, 1, 42);