OfficeWriter Documentation
.
ExcelWriter v10 Docs
Space Shortcuts
Page tree
    Loading...
Skip to end of metadata
Go to start of metadata

The Hyperlinks collection contains all hyperlinks in a worksheet. The Worksheet.Hyperlinks property returns a Hyperlinks collection.

C#
?
[DefaultMember("Item")]
 public sealed class Hyperlinks : System.Collections.Generic.IEnumerable<Hyperlink>
vb.net
?
<DefaultMember("Item")> _
    Public NotInheritable Class Hyperlinks
        Implements System.Collections.Generic.IEnumerable(Of Hyperlink)
C#
?
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Open(@"C:\MySpreadsheet.xls");
Worksheet ws = wb.Worksheets[0];
Hyperlinks links = ws.Hyperlinks;
vb.net
?
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xls")
Dim ws As Worksheet = wb.Worksheets(0)
Dim links As Hyperlinks = ws.Hyperlinks

Name

Description

Count

 Returns the number of hyperlinks in the worksheet.

Name

Description

Item(Int32)

 Returns the hyperlink at the specified 0-based index in the collection of hyperlinks in the worksheet.

Name

Description

CreateHyperlink(Area, String)

 Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks.

CreateHyperlink(Area, String, String)

 Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks.

GetEnumerator()

Returns an IEnumerator for the Hyperlinks in a Worksheet
  • No labels