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

keerthi sai

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...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohamed Elqassas9y ago
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 D9y ago
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\test.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 Moizuddin9y ago
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