Extract images from Microsoft Office Excel spreadsheets Leave feedback

To extract images from Microsoft Office Excel spreadsheets getImages methods are used. By default images are extracted with its original format. With using ImageOptions class it is possible to extract images from Microsoft Office Excel spreadsheets as bmp, gif, jpeg, png and webp formats.

Warning

getImages method returns null value if image extraction isn’t supported for the document. For example, image extraction isn’t supported for CSV files. Therefore, for CSV file getImages method returns null. If Microsoft Office Excel spreadsheet has no images,getImages method returns an empty collection.

Here are the steps to extract images from Microsoft Office Excel spreadsheet to PNG-files:

• Instantiate Parser object for the initial spreadsheet;
• Call getImages method and obtain the collection of image objects;
• Iterate through the collection and save image contents to the file.

The following example demonstrates how to extract images from Microsoft Office Excel spreadsheet:

// Create an instance of Parser class
try (Parser parser = new Parser(Constants.SampleWithImagesXlsx)) {
    // Extract images from spreadsheet
    Iterable<PageImageArea> images = parser.getImages();
    // Create the options to save images in PNG format
    ImageOptions options = new ImageOptions(ImageFormat.Png);
    int imageNumber = 0;
    // Iterate over images
    for (PageImageArea image : images)
    {
        // Save the image to the png file
        image.save(Constants.getOutputFilePath(String.format("%d.png", imageNumber)), options);
        imageNumber++;
    }
}

You may easily run the code above and see the feature in action in our GitHub examples:

• GroupDocs.Parser for .NET examples
• GroupDocs.Parser for Java examples

Along with full featured .NET library we provide simple, but powerful free Apps.

You are welcome to parse documents and extract data from PDF, DOC, DOCX, PPT, PPTX, XLS, XLSX, Emails and more with our free online Free Online Document Parser App.