/*------------------------------------------------------------------------------------
| Tutorial 15
|
| This tutorial shows how to create an Excel file with hyperlinks in C++.NET.
|
| EasyXLS supports the following hyperlink types:
| (1) - hyperlink to URL
| (2) - hyperlink to file
| (3) - hyperlink to UNC
| (4) - hyperlink to cell in the same Excel file
| (5) - hyperlink to name
| The link can be placed on a range of cells.
|
| Every type of hyperlink accepts a tool tip description.
|
| Every type of hyperlink accepts a text mark. A text mark is a link inside the file.
-----------------------------------------------------------------------------------*/using namespace System;
using namespace EasyXLS;
int main()
{
Console::WriteLine("Tutorial 15\n----------\n");
// Create an instance of the class that exports Excel files having two sheets
ExcelDocument ^workbook = gcnew ExcelDocument(2);
// Set the sheet names
ExcelWorksheet ^xlsTab1 = safe_cast<ExcelWorksheet^>(workbook->easy_getSheetAt(0));
ExcelWorksheet ^xlsTab2 = safe_cast<ExcelWorksheet^>(workbook->easy_getSheetAt(1));
xlsTab1->setSheetName("First tab");
xlsTab2->setSheetName("Second tab");
// Create hyperlink to URL
xlsTab1->easy_addHyperlink(EasyXLS::Constants::HyperlinkType::URL, "https://www.easyxls.com",
"Link to URL", "B2:E2");
// Create hyperlink to file
xlsTab1->easy_addHyperlink(EasyXLS::Constants::HyperlinkType::FILE, "c:\\myfile.xls", "Link to file", "B3");
// Create hyperlink to UNC
xlsTab1->easy_addHyperlink(EasyXLS::Constants::HyperlinkType::UNC, "\\\\computerName\\Folder\\file.txt",
"Link to UNC", "B4:D4");
// Create hyperlink to cell on second sheet
xlsTab1->easy_addHyperlink(EasyXLS::Constants::HyperlinkType::CELL, "'Second tab'!D3", "Link to CELL", "B5");
// Create a name on the second sheet
xlsTab2->easy_addName("Name", "=Second tab!$A$1:$A$4");
// Create hyperlink to name
xlsTab1->easy_addHyperlink(EasyXLS::Constants::HyperlinkType::CELL, "Name", "Link to a name", "B6");
// Export Excel file
Console::WriteLine("Writing file C:\\Samples\\Tutorial15 - hyperlinks in Excel.xlsx.");
workbook->easy_WriteXLSXFile("C:\\Samples\\Tutorial15 - hyperlinks in Excel.xlsx");
// Confirm export of Excel file
String ^sError = workbook->easy_getError();
if (sError->Equals(""))
Console::Write("\nFile successfully created. Press Enter to Exit...");
else
Console::Write(String::Concat("\nError encountered: ", sError, "\nPress Enter to Exit..."));
// Dispose memory
delete workbook;
Console::ReadLine();
return 0;
}
C++ without .NET Framework This tutorial is valid for C++ applications that can use .NET Framework. For applications that does not have .NET Framework integrated, a similar code sample is available.