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.

Pre-knowledge
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;
}


Comments

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:
    Email: