How to read images present in the column of Excel.
I used EPPlus to do that.
Here how it goes.
C# Code:
Here how it goes.
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); } } }
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