如何使用EPPlus从Excel文件(xlsx)获取/读取图片
问题描述:
假设我有一个名为 sheet1
的工作表,其中包含名为 pic_001
的图片。 System.Drawing.Image
对象。
Let's assume I have a worksheet named sheet1
which contain a picture named pic_001
How can I get this picture as System.Drawing.Image
object.
答
好,我知道了到:
public static Image GetImage(string sheetname, ExcelPackage excelFile)
{
var sheet = excelFile.Workbook.Worksheets[sheetname];
var pic = sheet.Drawings["pic_001"] as ExcelPicture;
return pic.Image;
}