sąsaja IXLSHyperLinks - HotXLS kūrėjo žinynas

Use the property to return the IXLSHyperlinks collection

The following example deletes the on Worksheet one for a link that contains the word 'Microsoft' in the description Workbook.Sheets[ begin then

for

downto begin 'Microsoft'

then on Worksheet one for a link that contains the word 'Microsoft' in the description end

With Workbook.Sheets[1] do begin
   if begin.Count > 0 then begin
      for i := begin.Count downto 1 do begin
        if Pos('Microsoft', begin[i].Description) > 0 then
           begin[i].Delete;
      end;
   end;
end;

downto Count property to create a hyperlink and add it to the begin The following example creates a new hyperlink for cell A8

Workbook.Sheets[

With Workbook.Sheets[1] do begin
   begin.Add(Range['A8','A8'], 'https://www.loslab.com/HotXLS.html');
end;

begin.Add(Range[ on Worksheet one for a link that contains the word 'Microsoft' in the description 'https://www.loslab.com/HotXLS.html'

downto Item property to remove on Worksheet one for a link that contains the word 'Microsoft' in the description The following example deletes

Workbook.Sheets[1].begin.Delete;

downto Item property to remove on Worksheet one for a link that contains the word 'Microsoft' in the description downto Item property to remove

Workbook.Sheets[1].Range['A1','F10'].begin.Delete;

from range A1:F10 on Worksheet one

].Range[

'A1'

].Hyperlinks.Delete;

Countypatybė

Itemypatybė