EPPlus insert image as Link to File in Excel document
In a Excel document, there is an option in the insert image dialog box, to insert a "Link to File", where Excel will display the image in the sheet without embedding it.
Like this: https://i.stack.imgur.com/AlGbW.png
How do I translate that functionality with EpPlus?
Note: This is not the same as using the "ws.Drawings.AddPicture()" method as shown below, as the "AddPicture()" method embeds the image, which is not what I'm trying to achieve.
Image logo = Image.FromFile(path);
ExcelPackage package = new ExcelPackage(info);
var ws = package.Workbook.Worksheets.Add("Test Page");
for(int a = 0; a < 5; a++)
{
ws.Row(a*5).Height = 39.00D;
var picture = ws.Drawings.AddPicture(a.ToString(), logo);
picture.SetPosition(a*5, 0, 2, 0);
}
链接地址: http://www.djcxy.com/p/75450.html