Function: colorRow()

function colorRow(worksheet: Worksheet, options: ColorRowOptions): void;

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

Color a specific row in a worksheet.

Parameters

Parameter	Type	Description
worksheet	Worksheet	The worksheet containing the row.
options	ColorRowOptions	Row coloring options including row number, color, exceptions, and fill style.

Returns

void

Example

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