ExVEx.OOXML.Styles (ExVEx v0.1.3)

Parser for xl/styles.xml.

The OOXML style model is an indirection graph: a cell carries a style index s="N" into cellXfs; each <xf> there points at a numFmt, font, fill, and border by further indices.

ExVEx parses the indirection arrays (numFmts, fonts, fills, borders, cellXfs) and exposes resolve/2 to flatten an <xf> index into a user-facing %ExVEx.Style{} record.

Built-in number format IDs (0..163) are not listed in numFmts at all; workbook-specific custom formats start at ID 164.

Summary

Functions

cell_format(styles, index)

date_format?(styles, cell_format)

Decides whether a cell format represents a date (or date-time / time).

format_code(styles, id)

The format code string for a given numFmt id, resolving built-ins.

parse(xml)

resolve(styles, index)

Dereferences a cell's style index into a flat %ExVEx.Style{} record. Returns a default style for nil (an unstyled cell).

serialize_into(styles, original_xml)

Re-serialises the stylesheet into its original XML container, rewriting only the <cellXfs> section. All other elements (fonts, fills, borders, cellStyles, dxfs, tableStyles, etc.) are preserved at the element level from original_xml.

upsert_date_format(styles, num_fmt_id)

Adds (or finds) an <xf> with the given numFmtId sitting on top of the default font / fill / border. Returns {index, updated_styles} — the index is the value that goes into a cell's s attribute.

Types

t()

@type t() :: %ExVEx.OOXML.Styles{
  borders: [ExVEx.Style.Border.t()],
  cell_formats: [ExVEx.OOXML.Styles.CellFormat.t()],
  fills: [ExVEx.Style.Fill.t()],
  fonts: [ExVEx.Style.Font.t()],
  num_fmts: [ExVEx.OOXML.Styles.NumFmt.t()]
}