Workbook.UpdateLinkedDataSource

Workbook.UpdateLinkedDataSource method

If this workbook contains external links to other data source, Aspose.Cells will attempt to retrieve the latest data from give sources.

public void UpdateLinkedDataSource(Workbook[] externalWorkbooks)
ParameterTypeDescription
externalWorkbooksWorkbook[]Workbooks that will be used to update data of external links referenced by this workbook. The match of those workbooks with external links is determined by FileName and DataSource. So please make sure FileName has been specified with the proper value for every workbook so they can be linked to corresponding external link.

Remarks

If corresponding external link cannot be found for one workbook, then this workbook will be ignored. So when you set a formula later with one new external link which you intend to make the ignored workbook be linked to it, the link cannot be performed until you call this this method again with those workbooks.

See Also