Skip to content

Nested Headers

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

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

MethodDescription
setNestedHeaderRemove 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
setNestedHeaderCellModify 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
resetNestedHeaderRemove nested header.

Jworksheet resetNestedHeader(): Promise<void>

DELETE /api/:guid/:worksheetIndex/nested