xlsx.ParsingOptions | /mod.ts | flat@0.0.15

interface xlsx.ParsingOptions

import { type xlsx } from "https://deno.land/x/flat@0.0.15/mod.ts";
const { ParsingOptions } = xlsx;

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