Interface Group

A group of rows or columns.

interface Group {
    collapsed: boolean;
    end: number;
    level: number;
    start: number;
    summary: number | null;
}

Index

Properties

collapsed end level start summary

Properties

collapsed

collapsed: boolean

Whether the details are collapsed: every one of them is hidden, whoever hid them.

Remarks

Read from the hidden details, as Excel reads it. A group whose summary is itself hidden, inside a collapsed outer group, reads collapsed only when it was collapsed before the outer one; expanding the outer group leaves such a group collapsed and opens the rest.

end

end: number

The last detail row or column, inclusive.

level

level: number

The level, from 1; level 1 is the outermost.

start

start: number

The first detail row or column.

summary

summary: number | null

The summary row or column, or null when the group runs to the edge of the sheet on the summary side.

Interface Group

Index

Properties

Properties

collapsed

Remarks

end

level

start

summary

Settings

On This Page