public void PictureURL()
{
var ws = _pck.Workbook.Worksheets.Add("Pic URL");
ExcelHyperLink hl = new ExcelHyperLink("http://epplus.codeplex.com");
hl.ToolTip = "Screen Tip";
ws.Drawings.AddPicture("Pic URI", Properties.Resources.Test1, hl);
}
public void Hyperlink()
{
var ws = _pck.Workbook.Worksheets.Add("HyperLinks");
var hl = new ExcelHyperLink("G1", "Till G1");
hl.ToolTip = "Link to cell G1";
ws.Cells["A1"].Hyperlink = hl;
}
//[Ignore]
//[TestMethod]
public void Hyperlink()
{
var ws = _pck.Workbook.Worksheets.Add("HyperLinks");
var hl = new ExcelHyperLink("G1", "Till G1");
hl.ToolTip = "Link to cell G1";
ws.Cells["A1"].Hyperlink = hl;
//ws.Cells["A2"].Hyperlink = new ExcelHyperLink("mailto:ecsomany@google:huszar", UriKind.Absolute); //Invalid URL will throw an Exception
}