Add Hyperlinks to the Cells

The following sample code shows how to add a hyperlink inside the cell of the worksheet. You can also add a hyperlink in a range of cells in a similar way. Please check the output excel file generated with this code and the following screenshot showing the output excel file in Microsoft Excel.

todo:image_alt_text

Sample Code

Aspose::Cells::Startup();
//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C
//Path of input
U16String dirPath(u"");
//Path of output
U16String outPath(u"");
//Path of output excel file
U16String outputAddHyperlinksToTheCells = outPath + u"outputAddHyperlinksToTheCells.xlsx";
//Create a new workbook
Workbook workbook;
//Get the first worksheet
WorksheetCollection wsc = workbook.GetWorksheets();
Worksheet ws = wsc.Get(0);
//Add hyperlink in cell C7 and make use of its various methods
HyperlinkCollection hypLnks = ws.GetHyperlinks();
int idx = hypLnks.Add(u"C7", 1, 1, u"http://www.aspose.com/");
Hyperlink lnk = hypLnks.Get(idx);
lnk.SetTextToDisplay(u"Aspose");
lnk.SetScreenTip(u"Link to Aspose Website");
//Save the workbook
workbook.Save(outputAddHyperlinksToTheCells);
Aspose::Cells::Cleanup();