ExternalLinkCollection class

ExternalLinkCollection class

Represents external links collection in a workbook.

The ExternalLinkCollection type exposes the following members:

Properties

PropertyDescription
countGets the number of elements actually contained in the collection.

Gets the ExternalLink element at the specified index.

Indexer

NameDescription
[index]The zero based index of the element.

Methods

MethodDescription
add(self, file_name, sheet_names)Adds an external link.
add(self, directory_type, file_name, sheet_names)Add an external link .
clear(self)Removes all external links.
clear(self, update_references_as_local)Removes all external links.
remove_at(self, index)Removes the specified external link from the workbook.
remove_at(self, index, update_references_as_local)Removes the specified external link from the workbook.

Example

from aspose.cells import Workbook

# Open a file with external links
workbook = Workbook("book1.xls")
# Change external link data source
workbook.worksheets.external_links[0].data_source = "d:\\link.xls"

See Also