WritingOptions | /deps/sheetjs.ts | lume@v2.4.1

interface WritingOptions

import { type WritingOptions } from "https://deno.land/x/lume@v2.4.1/deps/sheetjs.ts";

Options for write and writeFile

Properties

optional

type:

| "base64"

| "binary"

| "buffer"

| "file"

| "array"

| "string"

Output data encoding

optional

bookSST: boolean

Generate Shared String Table

optional

bookType: BookType

File format of generated workbook

optional

compression: boolean

Use ZIP compression for ZIP-based formats

optional

themeXLSX: string

Overwride theme XML when exporting to XLSX/XLSM/XLSB

optional

ignoreEC: boolean

Suppress "number stored as text" errors in generated files

optional

Props: Properties

Override workbook properties on save

optional

codepage: number

Desired codepage for legacy file formats

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

numbers: string

Base64 encoding of NUMBERS base for exports

optional

sheet: string | number

For single-sheet formats, export the specified worksheet.

The property must be a string (sheet name) or number (SheetNames index).

If this option is omitted, the first worksheet will be exported.

optional

FS: string

Field Separator ("delimiter") for CSV / Text output

optional

RS: string

Record Separator ("row separator") for CSV / Text output