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
The Hyperlinks collection contai=
ns all hyperlinks in a worksheet. The Worksheet.Hyperlinks property returns a Hyperlinks
collection.
[DefaultMember("Item")] public sealed class Hyperlinks : System.Collections.Generic.IEnumerable<= ;Hyperlink>=20
<DefaultMember("Item")> _ =09Public NotInheritable Class Hyperlinks =09=09Implements System.Collections.Generic.IEnumerable(Of Hyperlink)=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
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
Name | =20
Description | =20
---|---|
=20 | Returns the number of hyperlinks in the workshee= t. | =20
Name | =20
Description | =20
---|---|
=20 | Returns the hyperlink at the specified 0-based i= ndex in the collection of hyperlinks in the worksheet. | =20
Name | =20
Description | =20
---|---|
=20 | Creates a new hyperlink in the specified area of= cells. All cell values in the area will be converted to hyperlinks. | = =20
=20 | Creates a new hyperlink in the specified area of= cells. All cell values in the area will be converted to hyperlinks. | = =20
=20 | Returns an IEnumerator for the Hyperlinks in= a Worksheet | =20