Table of Contents

Namespace SheetStream.Styles

Classes

BorderOptions

Border settings of a StyleOptions.

CellStyle

A registered cell style. Obtain instances from Create(Action<StyleOptions>) and pass them to the cell-writing methods. Instances are immutable and cheap to share.

Colors

Helpers for building colour strings accepted by the style options.

DifferentialStyle

A differential format: the partial style (font colour and weight, fill, border, number format) that a conditional formatting rule lays over a cell when the rule matches. Create one with CreateDifferential(Action<StyleOptions>).

FillOptions

Fill settings of a StyleOptions. Only solid fills are supported.

FontOptions

Font settings of a StyleOptions.

NumberFormats

Frequently used Excel number format codes.

ProtectionOptions

Cell protection flags of a StyleOptions.

StyleOptions

Describes the appearance of a cell. Configure an instance (usually through Create(Action<StyleOptions>)) and the style sheet turns it into a registered, de-duplicated CellStyle.

StyleSheet

The workbook's style registry. Translates StyleOptions into the five interlocking tables SpreadsheetML needs (number formats, fonts, fills, borders and cell formats), de-duplicating each so a workbook with a thousand "bold blue header" cells carries a single font record.

Enums

BorderStyle

Line style of a cell border edge. Values map one-to-one onto ST_BorderStyle.

HorizontalAlignment

Horizontal text alignment inside a cell. Values map onto ST_HorizontalAlignment.

VerticalAlignment

Vertical text alignment inside a cell. Values map onto ST_VerticalAlignment.