Skip to main content
Module

x/sheetjs/types/index.d.ts>ParsingOptions

📗 SheetJS Community Edition -- Spreadsheet Data Toolkit
Extremely Popular
Latest
interface ParsingOptions
implements CommonOptions
import { type ParsingOptions } from "https://deno.land/x/sheetjs@v0.18.3/types/index.d.ts";

Options for read and readFile

Properties

optional
type:
| "base64"
| "binary"
| "buffer"
| "file"
| "array"
| "string"

Input data encoding

optional
codepage: number

Default codepage

optional
cellFormula: boolean

Save formulae to the .f field

optional
cellHTML: boolean

Parse rich text and save HTML to the .h field

optional
cellNF: boolean

Save number format string to the .z field

optional
cellText: boolean

Generate formatted text to the .w field

optional
dateNF: string

Override default date format (code 14)

optional
FS: string

Field Separator ("Delimiter" override)

optional
sheetRows: number

If >0, read the first sheetRows rows

optional
bookDeps: boolean

If true, parse calculation chains

optional
bookFiles: boolean

If true, add raw files to book object

optional
bookProps: boolean

If true, only parse enough to get book metadata

optional
bookSheets: boolean

If true, only parse enough to get the sheet names

optional
sheets: number | string | Array<number | string>

If specified, only parse the specified sheets or sheet names

optional
raw: boolean

If true, plaintext parsing will not parse values

optional
xlfn: boolean

If true, preserve _xlfn. prefixes in formula function names

optional
dense: boolean
optional
PRN: boolean