Hyperlinks

[Ducoli_Paolo]

Hi,
I have to handle hyperlinks in my workbooks.

I have had no problem to get/set hyperlink URL on cell. No problem to retrieve original range and so on ...

How about hyperlinks on object type Image ? I cannot find them in workbook HyperLinkCount property ...

Could you help me please ?

thanks !! :-)

[adrian]

Hi,

Hyperlinks in Excel can be of 3 kinds:

1) Normal "Cell" hyperlinks, handled with Get/SetHyperllink

2)"Formula" hyperlinks, like for example if you write in  a cell "=HYPERLINK("http://www.tmssoftware.com")"  Those hyperlinks are "old style" from really old Excel versions but they still work today, and if you need to handle them, you need to look at the formulas as they won't appear in the Hyperlink count.

3)Hyperlinks over images or objects. Again, this won't shown in the Hyperlink count properties, as they are a different thing. Those hyperlinks are attached to the objects, and to find them, you need to look at the objects themselves. Note that FlexCel handles image hyperlinks when exporting to html/pdf too, if you export a file with those, you will see the image hyperlinks are exported.

a code snippet you could use to fine the image hyperlinks in a sheet is like this:

        for (int i = 1; i <= xls.ObjectCount; i++)
        {
            TShapeProperties ShapeProps = xls.GetObjectProperties(i, true);
            THyperLink hl =  ShapeProps.ShapeOptions.AsHyperLink(TShapeOption.pihlShape, null);
            if (hl == null || hl.Text == null || hl.Text.Length == 0) continue;
            DoSomething(hl.Text);

        }

Regards,

Adrian.

Ps: This post was posted in FlexCel for VCL forums, but as you have a FlexCel.NET license, I answered for .NET.

I assumed it was just the wrong forum (as it is very easy to get confused), but if the question was really about VCL,

let me know and I will reanswer.

[Ducoli_Paolo]

Thanks for your fast reply.

How can I do to modify that hyperlink text ?

With normal hyperlink I use: xls.SetHyperlink ...

thanks !
paolo

[adrian]

You can add or modify an hyperlink in an object with the following code:

xls.SetObjectProperty(objectIndex, null, TShapeOption.pihlShape, new THperLink(THyperLinkType.URL, "http://www.tmssoftware.com", null, null, null));

Where objectIndex is the index (1 based of the object). If you know the name of the object instead, you can use:

xls.SetObjectProperty(0, "@objectname", TShapeOption.pihlShape, new THyperLink(THyperLinkType.URL, "http://www.tmssoftware.com", null, null, null));

[Ducoli_Paolo]

ok, perfect !
thanks
Paolo