Function setCellValue

  • setCellValue(worksheet, row, col, value): void

  • Sets the value of a cell in the worksheet by row and column index.

    Parameters

    • worksheet: Worksheet

      The ExcelJS worksheet.

    • row: number

      The 1-based row index.

    • col: number

      The 1-based column index.

    • value: any

      The value to set in the cell.

    Returns void

    Example

    setCellValue(worksheet, 2, 4, 'Done'); // sets D2 to 'Done'

Settings