Spire.xls picture hyperlink

[Meng0527]

I want to add a hyperlink to a picture in a workbook, and the hyperlink address is in the another worksheet of this workbook. How can i do this?
Thanks for your help!
Meng

[nancy.yang]

Hi,

Thanks for your inquiry.
Please refer to the following code to add a hyperlink for picture. If there is any question, please feel free to write back.

Code: Select all

            Workbook wb = new Workbook();
            wb.LoadFromFile("Input.xlsx");
            Worksheet sheet = wb.Worksheets[0];
            Worksheet sheet1 = wb.Worksheets[1];
            String url = sheet1.Range["A1"].Text;
            sheet.Pictures[0].SetHyperLink(url, true);
            wb.SaveToFile("Result.xlsx", ExcelVersion.Version2013);
            System.Diagnostics.Process.Start("Result.xlsx");


Sincerely,
Nancy
E-iceblue support team

[Meng0527]

thank u very much, your reply is exactly what i wanted. However,when I opened the workbook and click the picture, a message -- 'can not open the specified file' showed , and i am sure the hyperlink address is correct.Can you help me with this question?

[nancy.yang]

Hi,

Thanks for your feedback.
I looked back again for your previous description, and re-understood that your requirement is to add a hyperlink that refers to the range in another worksheet, am I right? If so, please use the code below to achieve it. Just feel free to write back if there is any question.

Code: Select all

            Workbook wb = new Workbook();
            wb.LoadFromFile("Input.xlsx");
            Worksheet sheet = wb.Worksheets[0];
            Worksheet sheet1 = wb.Worksheets[1];
            sheet.Pictures[0].SetHyperLink("#Sheet2!A1", false);
            wb.SaveToFile("Result.xlsx", ExcelVersion.Version2013);


Sincerely,
Nancy
E-iceblue support team

[Meng0527]

Thank u for your help, and my problem has been solved.

Sincerely!

[nancy.yang]

Hi,

Thanks for your feedback.
If there is anything we can do for you in the future, please do not hesitate to contact us.
Wish you all the best!

Sincerely,
Nancy
E-iceblue support team

[Meng0527]

When i want to modify a hyperlink(not a picture hyperlink) as following, but when i open the excel and click the hyperlink, it says "invalid reference":

Code: Select all

HyperLinksCollection links = dest_worksheet.HyperLinks;
links[0].SetAddress("#Issue summary!C14", false);


[Lisa.Li]

Hello,

Thanks for your feedback.
After an initial test, I didn't reproduce your issue, the hyperlink address could be modified successfully on my side. To help us further look into it, please provide your testing Excel file. You could send it via email (support@e-iceblue.com).

Sincerely,
Lisa
E-iceblue support team

[Meng0527]

I have already sent an email to the mailbox.
Thanks

[Lisa.Li]

Hello,

Sorry that I didn't get your email, please help to check on your side or you could send it to (lisa.li@e-iceblue.com) directly. Thanks in advance.

Sincerely,
Lisa
E-iceblue support team

[Meng0527]

I sent an email to you just now

[Lisa.Li]

Hello,

Thank you for sharing your sample file via email.
Since the first sheet name “Issue summary” of your file contains a space, based on the internal mechanism of MS Excel itself, the sheet name will be added ‘’ automatically when referencing and it will be “ ‘Issue summary’ “. Thus, you have to replace "#Issue summary!C14" with "#'Issue summary'!C14" to get rid of your issue. If there is any question, just feel free to write back.

Sincerely,
Lisa
E-iceblue support team