ParsingOptions | /deps/sheetjs.ts | lume@v1.17.5

interface ParsingOptions

import { type ParsingOptions } from "https://deno.land/x/lume@v1.17.5/deps/sheetjs.ts";

Options for read and readFile

Properties

optional

type:

| "base64"

| "binary"

| "buffer"

| "file"

| "array"

| "string"

Input data encoding

optional

codepage: number

Default codepage for legacy files

This requires encoding support to be loaded. It is automatically loaded in xlsx.full.min.js and in CommonJS / Extendscript, but an extra step is required in React / Angular / Webpack ESM deployments.

Check the relevant guide https://docs.sheetjs.com/docs/getting-started/

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

nodim: boolean

If true, ignore "dimensions" records and guess range using every cell

optional

xlfn: boolean

If true, preserve _xlfn. prefixes in formula function names

optional

dense: boolean

optional

PRN: boolean