Matterway
    Preparing search index...

    Function colorRow

    • 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

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