Get the images from Excel sheet and store in Local Folder...

Question

Hi.., Plz Help me, I have Excel File it contains lot of columns , 1 of the columns contains Images , i need to read images and store in Local folder (physically),,, plz help me...

Mohamed Elqassas · Answer

without code try the following: Change the excel file from xslx to zip. right click on the file and extract the file. it should be shown in a media file for more details check https://www.howtogeek.com/50628/easily-extract-images-text-and-embedded-files-from-an-office-2007-document/

Leon D · Answer

Hi Keerthi, You can use Free Spire.XLS to read image from excel, refer below code: using System.Drawing.Imaging; using Spire.Xls; namespace Extract_Image { class Program { static void Main( string [] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@ "C:\Users\Administrator\Desktop	est.xlsx" ); Worksheet sheet = workbook.Worksheets[0]; ExcelPicture picture = sheet.Pictures[0]; picture.Picture.Save(@ "Image\image.png" , ImageFormat.Png); } } } Reference: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Image/How-to-Extract-Image-from-Excel-Worksheet-in-C-VB.NET.html

Khaja Moizuddin · Answer

http://www.aspforums.net/Threads/159649/How-to-read-images-from-Excel-file-using-C-Net/ http://joymonscode.blogspot.in/2009/01/reading-image-from-excel-file.html https://janewdaisy.wordpress.com/2011/11/02/c-read-image-from-excel/ http://www.nullskull.com/q/10355780/how-to-extract-the-image-from-ms-excel.aspx Refer these above links

Get the images from Excel sheet and store in Local Folder...

Answers (3)