Skip to main content
Module

x/flat/mod.ts>xlsx.CellObject

A collection of postprocessing utilities for flat
Latest
interface xlsx.CellObject
import { type xlsx } from "https://deno.land/x/flat@0.0.15/mod.ts";
const { CellObject } = xlsx;

Worksheet Cell Object

Properties

optional
v:
| string
| number
| boolean
| Date

The raw value of the cell. Can be omitted if a formula is specified

optional
w: string

Formatted text (if applicable)

The Excel Data Type of the cell. b Boolean, n Number, e Error, s String, d Date, z Empty

optional
f: string

Cell formula (if applicable)

optional
F: string

Range of enclosing array if formula is array formula (if applicable)

optional
r: any

Rich text encoding (if applicable)

optional
h: string

HTML rendering of the rich text (if applicable)

optional
c: Comments

Comments associated with the cell

optional
z: NumberFormat

Number format string associated with the cell (if requested)

optional
l: Hyperlink

Cell hyperlink object (.Target holds link, .tooltip is tooltip)

optional
s: any

The style/theme of the cell (if applicable)