Skip to content

WorkbookDescription

new WorkbookDescription(wb, options?): WorkbookDescription;

Workbook

Partial<DescriptionOptions>

WorkbookDescription

calculated: ChunkNode[] = [];

cellR1C1formula: DefaultMap<CellItem, string | null>;

chunkedGraph: DependencyGraph<ChunkNode, KnownVertexId>;

formulaRangeRTrees: DefaultMap<number, RTree<RangeFormulaNode>>;

labels: Label[];

names: DefinedNameDescription[];

options: DescriptionOptions;

parameters: Parameter[];

sheets: SheetDescription[];

summary:
| {
calculated: object[];
description: string;
parameters: object[];
wbId: string;
}
| null;

totalFormulas: number;

workbook: Workbook;
cellReference(vertexId): Reference | undefined;

CellVertexId | NameVertexId

Reference | undefined


describeValues(lab): string | undefined;

Labeled

string | undefined


extractAllText(): Set<string>;

Set<string>


getCalculated(cellOrRef): ChunkNode | undefined;

Reference | CellItem

ChunkNode | undefined


getCellLabel(cellOrRef): string;

Reference | CellItem

string


getParameter(cellOrRef): Parameter | undefined;

Reference | CellItem

Parameter | undefined


isParameter(vertexId, sheetIndex): boolean;

CellVertexId

number

boolean


labelString(label): string;

Label

string


likelyLabels(vertexId): readonly Label[];

KnownVertexId

readonly Label[]


setSummary():
| {
calculated: object[];
description: string;
parameters: object[];
wbId: string;
}
| null;

| { calculated: object[]; description: string; parameters: object[]; wbId: string; } | null


toString(): string;

string