ExternalLinkCollection

ExternalLinkCollection class

Represents external links collection in a workbook.

public class ExternalLinkCollection : IEnumerable

Properties

Name Description
Count { get; } Gets the number of elements actually contained in the collection.
Item { get; } Gets the ExternalLink element at the specified index.

Methods

Name Description
Add(string, string[]) Adds an external link.
Add(DirectoryType, string, string[]) Add an external link .
Clear() Removes all external links.
Clear(bool) Removes all external links.
GetEnumerator() Get an enumerator that iterates through this collection.
RemoveAt(int) Removes the specified external link from the workbook.
RemoveAt(int, bool) Removes the specified external link from the workbook.

Examples

[C#]
//Open a file with external links
Workbook workbook = new Workbook("book1.xls");

//Change external link data source
workbook.Worksheets.ExternalLinks[0].DataSource = "d:\\link.xls";


[Visual Basic]
'Open a file with external links
Dim workbook As Workbook =  New Workbook("book1.xls")

'Change external link data source
workbook.Worksheets.ExternalLinks(0).DataSource = "d:\\link.xls"

See Also