Message-ID: <1415511907.7639.1711616482368.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7638_1259672119.1711616482368" ------=_Part_7638_1259672119.1711616482368 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Hyperlinks

Hyperlinks

=20

The Hyperlinks collection contai= ns all hyperlinks in a worksheet. The Worksheet.Hyperlinks property returns a Hyperlinks collection.

=20
C#
=20
[DefaultMember("Item")]
 public sealed class Hyperlinks : System.Collections.Generic.IEnumerable<=
;Hyperlink>
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class Hyperlinks
=09=09Implements System.Collections.Generic.IEnumerable(Of Hyperlink)
=20
=20 =20
C#
=20

          ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Open(@"C:\MySpreadsheet.xls");
          Worksheet ws =3D wb.Worksheets[0];
          Hyperlinks links =3D ws.Hyperlinks;
        
=20
=20
vb.net
=20

          Dim xla As New ExcelApplication()
          Dim wb As Workbook =3D xla.Open("C:\MySpreadsheet.xls")
          Dim ws As Worksheet =3D wb.Worksheets(0)
          Dim links As Hyperlinks =3D ws.Hyperlinks
        
=20
=20 =20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Cou= nt

Returns the number of hyperlinks in the workshee= t.
=20 =20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Item(Int32)

Returns the hyperlink at the specified 0-based i= ndex in the collection of hyperlinks in the worksheet.
=20 =20
=20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20

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

------=_Part_7638_1259672119.1711616482368--