Reading images from Excel using office interop

We can't directly retrieve image using the Excel Office interop.We have to send the image to clipboard and then get from there.

Knowledge in Office interop

Picture pict=workSheet.Pictures("pictureName") as Picture;//workSheet is object of excel sheet
pict.CopyPicture(XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlBitmap);//Copy to clipboard

//Get from clipboard
if (Clipboard.ContainsImage()){
Image img=Clipboard.GetImage();
pictureBox.Image = img;


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: