Wednesday, December 19, 2018

Read Image from Excel

How to read images present in the column of Excel. I used EPPlus to do that.
Here how it goes.
C# Code:
using OfficeOpenXml; using OfficeOpenXml.Drawing;
namespace ExcelRead {     public void Index()     {         using (ExcelPackage pck = new ExcelPackage())         {             FileStream fileStream = new FileStream(
@"C:\Docs\Pictures.xlsx", FileMode.Open, FileAccess.ReadWrite);
            pck.Load(fileStream);             GetImage(pck);         };     }              public static void GetImage(ExcelPackage excelFile)     {         var sheet = excelFile.Workbook.Worksheets.First();         foreach (ExcelDrawing i in sheet.Drawings)         {             string picname = i.Name;             ExcelPicture pic = sheet.Drawings[i.Name] as ExcelPicture;             Image img = pic.Image;             img.Save(@"C:\Docs\" + i.Name + ".png", ImageFormat.Png);         }     } }

No comments:

Post a Comment