Internal Hyperlink & ExcelDesigner

Aspose.Cells Product Family
1

I am using a template with internal hyperlinks linking from one sheet to another. After saving the processed file the links and screen tips are gone. Is there anyway to preserve these links while using ExcelDesigner?

Thanks,

ayu

2

Please try this attached fix.

3

Thank you for your quick response. Unfortunately, it still doesn’t
work. I think the hyperlinks are lost immediately after ExcelDesigner
opens the template.



Aspose.Excel.ExcelDesigner ex = new Aspose.Excel.ExcelDesigner();

ex.Open(“c:\template.xls”);

// ex.Excel.Worksheets[0].Hyperlinks.Count at this point is 0.

// Even
though there are several links on that sheet in the template.

4

1. Hyperlinks class only contains hyperlinks setting at run time.

2. Please check the version of Aspose.Excel in your project. Which version is it?

Please try the following sample code with the attached file:

ExcelDesigner designer = new ExcelDesigner();
designer.Open("d:\\sample1.xls");
designer.Save("d:\\abc.xls");

Could you please check if it works fine in your machine? And which version of MS Excel are you using?

5

Hi,



I think I’ve found the problem. The hyperlink was moved down during the
process. If you try the following code with the attached file you would
see:


  1. The Screen Tip is gone.
  2. The link was moved from E11 to E12.



    I am using Excel 2003 with Aspose.Excel 3.5.1.0



    Thanks again for your timely response.



    Aspose.Excel.ExcelDesigner ex = new Aspose.Excel.ExcelDesigner();

    ex.Open(“C:\sample1.xls”);

    DataTable table = new DataTable();

    table.TableName = “Table”;

    table.Columns.Add(“Test”);

    table.Rows.Add(new object [1] {1});

    table.Rows.Add(new object [1] {2});

    ex.SetDataSource(table);

    ex.Process();

    ex.Save(“C:\test.xls”);


6

Thanks for you help.

Please try this fix.