HotXLS-dokumentation Indhold Startside Oversigt TGridToXLS IXLSWorkbook Startside Indhold Oversigt

grænseflade IXLSHyperLinks

Enhed: lxHandle

Repræsenterer the collection of hyperlinks for a Worksheet or range. Each hyperlink is represented by an IXLSHyperlink Interface

Using the Hyperlinks Collection

Use the Hyperlinks property to return the IXLSHyperlinks collection The following example deletes the hyperlinks on Worksheet one for a link that contains the word 'Microsoft' in the description With Workbook.Sheets[1] do begin if Hyperlinks.Count > 0 then begin for i := Hyperlinks.Count downto 1 do begin if Pos('Microsoft', Hyperlinks[i].Description) > 0 then Hyperlinks[i].Delete; end; end; end; Use the Add method to create a hyperlink and add it to the Hyperlinks collection The following example creates a new hyperlink for cell A8 With Workbook.Sheets[1] do begin Hyperlinks.Add(Range['A8','A8'], 'https://www.loslab.com/HotXLS.html'); end; Use the Delete method to remove hyperlinks from a Worksheet or range The following example deletes hyperlinks from Worksheet one Workbook.Sheets[1].Hyperlinks.Delete; The following example deletes hyperlinks from range A1:F10 on Worksheet one Workbook.Sheets[1].Range['A1','F10'].Hyperlinks.Delete;

Egenskaber

Countegenskab Itemegenskab

grænseflade IXLSHyperLinks

Enhed: lxHandle

Using the Hyperlinks Collection

Egenskaber

Metoder