private void InsertHyperlinks(string file)
{
var dic = new Dictionary <string, string>
{
{ "A1", "https://www.url.com/" }, // with '/' on the end
{ "B2", "mailto:[email protected]" },
{ "C3", "../sample.txt" },
{ "D4", "Sheet2!E10" },
{ "E5", "ftp://some.ftp.com" } // without '/' on the end
};
foreach (var item in dic)
{
var workflow = new InsertHyperlink
{
UseScope = false,
WorkbookPath = file,
Cell = item.Key,
Link = item.Value,
SheetName = "Sheet1"
};
WorkflowTester.Invoke(workflow);
}
}
[DataRow("A11", "ftp://some.ftp.com", "FTP")] // without '/' on the end
public void OLE2(string cell, string link, string label)
{
var args = CreateInsertHyperlinkArgs(_ole2file, cell, link, label);
var workflow = new InsertHyperlink {
UseScope = false
};
var result = WorkflowTester.Invoke(workflow, args);
Assert.IsTrue(result);
}
