Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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

Signature
C#
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)
{signature}
{example}{code:csharp|title=C#}
Example
Code Block
csharp
csharp
titleC#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xls");
          Worksheet ws = wb.Worksheets[0];
          Hyperlinks links = ws.Hyperlinks;
        
{code} {code:vbnet|title=
Code Block
vbnet
vbnet
titlevb.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
        
{code} {example} {properties} ||Name||Description|| |[Count|Hyperlinks.Count]|{excerpt-include:Hyperlinks.Count|nopanel=true}| {indexers} ||Name||Description|| |[Item(Int32)|
Properties

Name

Description

Count

Excerpt Include
Hyperlinks.Count
Hyperlinks.Count
nopaneltrue
Indexers

Name

Description

Item(Int32)

Excerpt Include
Hyperlinks.Item(Int32)

...

Hyperlinks.Item(Int32)

...

nopanel

...

true
Methods

Name

Description

CreateHyperlink(Area,

...

...

Excerpt Include
Hyperlinks.CreateHyperlink(Area,

...

String)

...

Hyperlinks.CreateHyperlink(Area,

...

String)

...

nopanel

...

...

...

...

Excerpt Include
Hyperlinks.CreateHyperlink(Area,

...

String,

...

String)

...

Hyperlinks.CreateHyperlink(Area,

...

String,

...

String)

...

nopanel

...

...

Excerpt Include
Hyperlinks.GetEnumerator()

...

Hyperlinks.GetEnumerator()

...

nopanel

...

true

...