Skip to content

@sheetkit/node / DateInterpretation

Type Alias: DateInterpretation

DateInterpretation = "cellType" | "numFmt"

Defined in: index.ts:138

Controls how date-formatted number cells are interpreted while reading.

  • "numFmt" (default): promote t="n" (or untyped) cells whose style points at a built-in date format ID (14-22, 45-47) or a custom format code containing date/time tokens to a date cell. Matches how Microsoft Excel stores dates in practice.
  • "cellType": follow the cell's t attribute strictly. A t="n" cell remains a number even when its style references a date number format; only t="d" cells are returned as dates. Opt in when you need spec-literal behavior.

Released under the MIT / Apache-2.0 License.