Edit

ExcelScript.LinkedWorkbook interface

  • Reference
Package:
ExcelScript

Contains information about a linked workbook. If a workbook has links pointing to data in another workbook, the second workbook is linked to the first workbook. In this scenario, the second workbook is called the "linked workbook".

Methods

breakLinks()

Makes a request to break the links pointing to the linked workbook. Links in formulas are replaced with the latest fetched data. The current LinkedWorkbook object is invalidated and removed from LinkedWorkbookCollection.
refreshLinks()

Makes a request to refresh the data retrieved from the linked workbook.

Method Details

Makes a request to break the links pointing to the linked workbook. Links in formulas are replaced with the latest fetched data. The current LinkedWorkbook object is invalidated and removed from LinkedWorkbookCollection.

breakLinks(): void;

Returns

void

Makes a request to refresh the data retrieved from the linked workbook.

refreshLinks(): void;

Returns

void