HyperLinkCellType problem

Posted by: slava on 8 September 2017, 2:31 pm EST

  • Posted 8 September 2017, 2:31 pm EST

    Hi! I'm using HyperLinkCellType to make contents table in just created excel file.

    var sheet = new SheetView {SheetName = "Contents"};
    foreach (var link in contents)
    {
        var cell = sheet.Cells[link.Position + 1, 1];
        var linkCell = new HyperLinkCellType
                           {
                               Text = link.Text,
                               Link = string.Format("'{0}'!A1", link.Sheet),
                               LinkColor = Color.DarkGreen,
                               VisitedLinkColor = Color.Chartreuse,
                               LinkArea = new LinkArea(0, link.Text.Length)
                           };

        cell.CellType = linkCell;
    }
    spread.Sheets.Add(sheet);

    ...

    spread.SaveExcel(outputName, ExcelSaveFlags.UseOOXMLFormat | ExcelSaveFlags.AutoRowHeight | ExcelSaveFlags.NoFormulas);

    I combine almost all flags in SaveExcel method... But where are only text in output xlsx file. Can you tell my, that's wrong?

    Thanks for help,

    Slava

  • Replied 8 September 2017, 2:31 pm EST

    Hello,

    Currently there is no way through which Hyperlinks in Spread can be exported to excel file.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels