Retrieve pictures from Excel file using OLEDB

Question

I have an Excel sheet with two column, one is a number , and second column have a picture. i want to read these data from c# with oledb connection, i can read number easily , but pictures is not contained in second column , so in c# i just get first column.

now, how can i read the images ? i want to extract the numbers and related images from this excel sheet.

Answer 1

Not possible, I'm afraid.

Pictures do not live in cells -- you can place them over the cell, and you can size them to look like they are in the cell, but they in no way occupy that cell.

You can manipulate image contents of a worksheet using VBA and COM interop, but not OLEDB.