Skip to main content
Using Deno in production at your company? Earn free Deno merch.
Give us feedback
Module

x/lume/deps/sheetjs.ts>WritingOptions

🔥 Static site generator for Deno 🦕
Very Popular
Go to Latest
interface WritingOptions
implements CommonOptions
import { type WritingOptions } from "https://deno.land/x/lume@v2.2.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