在单元格中添加超链接

在单元格中添加超链接

以下示例代码显示了如何在工作表的单元格中添加超链接。您也可以以类似的方式在一系列单元格中添加超链接。请查看使用此代码生成的输出excel文件以及显示输出excel文件的以下屏幕截图。

todo:image_alt_text

示例代码

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();