Type Alias External

A cell from another workbook (i.e. another file) that is referenced in this workbook.

type External = {
    name: string;
    names: DefinedName[];
    pathMissing?: boolean;
    sheets: ExternalWorksheet[];
}

Properties

name: string

Filename being referenced.

Relevant defined names from an external workbook.

pathMissing?: boolean

Indicates that the path to the external workbook file is unknown or missing. In XLSX, this corresponds to the xlPathMissing relationship type.

Relevant worksheets from an external workbook.

These will only be a subset of sheets needed to run calculations, so indexes from the original workbooks will not be preserved.