Results 1 to 2 of 2

Thread: [RESOLVED] Extract images from excel

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Dec 2009
    Location
    sydney
    Posts
    265

    Resolved [RESOLVED] Extract images from excel

    Hello,

    I have an excel sheet with over 100 images in the second column.

    I wrote a consol app to retrieve and save images on a local folder however the Workheet.Pictures collection appears to be empty when I run the code. and only access the images that are added recently ( for testing)
    Code:
    Workbook workbook = new Workbook();
    
     workbook.LoadFromFile(XLpath);
               
    Worksheet sheet =  workbook.Worksheets[0];
    //sheet.Pictures.Count() // returns 0
    The sheet is not protected, and my code works on another file

    Any ideas ?

    Thanks

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Dec 2009
    Location
    sydney
    Posts
    265

    Re: Extract images from excel

    Quote Originally Posted by wiss.dev View Post
    Hello,

    I have an excel sheet with over 100 images in the second column.

    I wrote a consol app to retrieve and save images on a local folder however the Workheet.Pictures collection appears to be empty when I run the code. and only access the images that are added recently ( for testing)
    Code:
    Workbook workbook = new Workbook();
    
     workbook.LoadFromFile(XLpath);
               
    Worksheet sheet =  workbook.Worksheets[0];
    //sheet.Pictures.Count() // returns 0
    The sheet is not protected, and my code works on another file

    Any ideas ?

    Thanks
    Turned out that images were embedded as object

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width