OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 5

changes.mady.by.user Anonymous

Saved on

compared with

New Version Current

changes.mady.by.user Anonymous

Saved on

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, 
...
 String)
...
 Excerpt Include
Hyperlinks.CreateHyperlink(Area, 
...
 String)
...
Hyperlinks.CreateHyperlink(Area, 
...
 String)
...
nopanel
...
true
CreateHyperlink(Area, 
...
 String, 
...
 String)
...
 Excerpt Include
Hyperlinks.CreateHyperlink(Area, 
...
 String, 
...
 String)
...
Hyperlinks.CreateHyperlink(Area, 
...
 String, 
...
 String)
...
nopanel
...
true
GetEnumerator()
...
 Excerpt Include
Hyperlinks.GetEnumerator()
...
Hyperlinks.GetEnumerator()
...
nopanel
...
true
...