天天看點

EPPLUS讀取指定單元格内的圖檔

百度,google找了好一會兒沒找到怎麼擷取指定單元格内的圖檔,隻能自己研究了

添加引用

using OfficeOpenXml;
using System.IO;
using System.Linq;
           

完整代碼

using (ExcelPackage pck = new ExcelPackage(path))
{
    string pathurl = Path.Combine(path, "pic");//指定圖檔儲存目錄
    if (!Directory.Exists(pathurl))
    {
       Directory.CreateDirectory(pathurl);
    }
    ExcelWorksheet source_ws = pck.Workbook.Worksheets.FirstOrDefault();//讀取第一個sheet表
    var excelPicture = source_ws.Drawings.Where(o => o.From.Row == 1  && o.From.Column == 
    1).FirstOrDefault() as OfficeOpenXml.Drawing.ExcelPicture;//擷取第一行第一列單元格内的圖檔
    var filepath = Path.Combine(pathurl, string.Format("{0}.jpg", DateTime.Now.ToFileTime()));//指定檔案名
    excelPicture.Image.Save(filepath, System.Drawing.Imaging.ImageFormat.Jpeg);//儲存圖檔
                    
}
           

繼續閱讀