Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

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

{signature}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xls");
          Worksheet ws = wb.Worksheets[0];
          Hyperlinks links = ws.Hyperlinks;
        
{code}
{code:vbnet|title=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
        
Signature
C#C#
Wiki Markup
{description}
{excerpt}The [Hyperlinks|Hyperlinks] collection contains all hyperlinks in a worksheet. The [Worksheet.Hyperlinks|Worksheet.Hyperlinks] property returns a {{Hyperlinks}} collection.{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class Hyperlinks : System.Collections.Generic.IEnumerable<Hyperlink>
Signature
{signature}{signature:vb.net
vb.net
}
<DefaultMember("Item")> _
	Public NotInheritable Class Hyperlinks
		Implements System.Collections.Generic.IEnumerable(Of Hyperlink)
Example
Code Block
csharpcsharp
titleC#
Code Block
vbnetvbnettitle
Properties

...

Name

...

Description

...

Count

...

{code}

{example}
{properties}
||Name||Description||
|[Count|Hyperlinks.Count]|{excerpt-include:Hyperlinks.Count

...

Indexers

...

Name

...

Description

|nopanel=true}|
{indexers}
||Name||Description||
|[Item(Int32)

...

|Hyperlinks.Item(Int32)

...

]|{excerpt-include:Hyperlinks.Item(Int32)

...

|nopanel

...

Methods

...

Name

...

Description

=true}|
{methods}
||Name||Description||
|[CreateHyperlink(Area, String)

...

|Hyperlinks.CreateHyperlink(Area, String)

...

]|{excerpt-include:Hyperlinks.CreateHyperlink(Area, String)

...

|nopanel

...

=true}|
|[CreateHyperlink(Area, String, String)

...

|Hyperlinks.CreateHyperlink(Area, String, String)

...

]|{excerpt-include:Hyperlinks.CreateHyperlink(Area, String, String)

...

|nopanel

...

=true}|
|[GetEnumerator()

...

|Hyperlinks.GetEnumerator()

...

]|{excerpt-include:Hyperlinks.GetEnumerator()

...

|nopanel

...

=true}|