Function colorRow

  • colorRow(worksheet, options): void

  • Colors a specific row in the given worksheet using the provided options.

    Parameters

    • worksheet: Worksheet

      The worksheet containing the row to be colored.

    • options: ColorRowOptions

      Options for row coloring, including row number, color, exceptions, and fill style.

    Returns void

    Example

    const worksheet = workbook.getWorksheet(1);
    colorRow(worksheet, {
      rowNumber: 5,
      color: 'FF00FF00',
      exceptions: [{ column: 2, color: 'FFFF0000' }],
      fill: { type: 'pattern', pattern: 'solid' },
    });

Settings