Parse imported text as a literal using the same boolean, number, date, and
currency rules as parseCellInput. Unlike interactive entry, a leading
= remains inert text. Declared date columns also accept an existing finite
date serial so delimited export/import preserves numeric dates.
Package
@sheetwrite/core
Source
packages/core/src/cell-input.ts#L73
Declaration
functionparseCellLiteralInput(
raw:string,
type:CellFormattype CellFormat = "text" | "number" | "date" | "currency";typeCellFormat="text"|"number"|"date"|"currency";typeCellFormat=|"text"|"number"|"date"|"currency";How a column's cells are typed, parsed, and rendered: text verbatim, number via its numberFormat, date as an Excel-style serial (see date-serial.ts) rendered by a date numberFormat, and currency as a plain number rendered by a currency numberFormat (e.g. $#,##0.00).API reference →,
):CellScalartype CellScalar = string | number | boolean | null;typeCellScalar=string|number|boolean|null;typeCellScalar=|string|number|boolean|null;A scalar that can be displayed directly.API reference →