Products

Nested Headers

This section covers the methods to handle with the spreadsheet nested headers.

Documentation

Methods

The following methods are available to interact with the spreadsheet nested headers programmatically.

Method Description
setNestedHeader Remove the current nested header, if any, and set the new nested header.
@param nestedHeader - new nested header.

Jworksheet setNestedHeader(nestedHeader: Nested[][]): Promise<void>

POST /api/:guid/:worksheetIndex/nested
setNestedHeaderCell Modify the properties of one or more nested header cells.
@param nestedHeaderCells.x - horizontal cell position.
@param nestedHeaderCells.y - vertical cell position.
@param nestedHeaderCells.properties - cell properties.

Jworksheet setNestedHeaderCell(nestedHeaderCells: { x: number; y: number; properties: Nested; } | { x: number; y: number; properties: Nested; }[]): Promise<void>

POST /api/:guid/:worksheetIndex/nested/update
resetNestedHeader Remove nested header.

Jworksheet resetNestedHeader(): Promise<void>

DELETE /api/:guid/:worksheetIndex/nested