Type Alias External

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

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

Index

Properties

name names sheets

Properties

name

name: string

Filename being referenced.

names

names: DefinedName[]

Relevant defined names from an external workbook.

sheets

sheets: ExternalWorksheet[]

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.