Skip to main content

RangeFormat

Excel.RangeFormat. Import from @reductoai/xlsx/officejs.

RangeFormat properties

RangeFormat.adjustIndent()

Moves each cell’s indent by amount characters, kept within 0 to 250.

RangeFormat.autofitColumns()

Sizes each column to its widest displayed value, measured in each cell’s own font as Excel does.

RangeFormat.autofitRows()

Clears custom heights, so Excel sizes the rows to their content on open.

RangeFormat.set()

Sets several properties at once; a navigation member takes a nested batch.

RangeFont

Excel.RangeFont. Import from @reductoai/xlsx/officejs.

RangeFont properties

RangeFont.set()

Sets several properties at once; a navigation member takes a nested batch.

RangeFill

Excel.RangeFill: solid and pattern fills; gradients read only. Import from @reductoai/xlsx/officejs.

RangeFill properties

RangeFill.clear()

RangeFill.set()

Sets several properties at once; a navigation member takes a nested batch.

RangeBorder

Excel.RangeBorder. Import from @reductoai/xlsx/officejs.

RangeBorder properties

RangeBorder.set()

Sets several properties at once; a navigation member takes a nested batch.

RangeBorderCollection

Excel.RangeBorderCollection. Import from @reductoai/xlsx/officejs.

RangeBorderCollection properties

RangeBorderCollection.getItem()

RangeBorderCollection.getItemAt()

FormatProtection

Excel.FormatProtection: what sheet protection does to the cells. Import from @reductoai/xlsx/officejs.

FormatProtection properties

FormatProtection.set()

Sets several properties at once.

Style

Excel.Style. Import from @reductoai/xlsx/officejs.

Style properties

Style.delete()

Cells of the style keep how they look and become Normal; Normal cannot be deleted.

Style.set()

StyleCollection

Excel.StyleCollection. Import from @reductoai/xlsx/officejs.

StyleCollection properties

StyleCollection.add()

A new style with Normal’s format; the name must be new.

StyleCollection.getCount()

StyleCollection.getItem()

StyleCollection.getItemAt()

StyleCollection.getItemOrNullObject()