Extract attachments from XLS file with Aspose.Cells for Java API

Aspose.Cells Product Family
1

Cannot extract attachments using:

    String fileName = "/tmp/native-excel95-embedded-word-document.xls";
    Workbook workbook = new Workbook(fileName);

    int count = 0;
    for (Worksheet sheet : (Iterable<Worksheet>)workbook.getWorksheets()) {
        for (OleObject obj : (Iterable<OleObject>) sheet.getOleObjects()) {
            count ++;
        }
    }

    System.out.println("This file has "+ count+ " embedded  files ");

From file:

https://www.dropbox.com/s/dp7pt7wp6g9rcpy/native-excel-embedded-word-document.xls?dl=0

2

@russ.nichols,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42931 - Attachments/Objects not fetched from Excel95
3

@russ.nichols,
We have investigated it a bit more and I am afraid that the API currently does not support to load objects of Shapes, Charts, OleObjects…, etc. from Excel95 template files.

4

@russ.nichols,
This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42931”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

5

@russ.nichols,
Please try our latest version/fix: Aspose.Cells for Java v19.11.5:
aspose-cells-19.11.5.zip (6.7 MB)

Your issue should be fixed in it.

Let us know your feedback.

6

The issues you have found earlier (filed as CELLSJAVA-42931) have been fixed in Aspose.Cells for Java v19.12. This message was posted using Bugs notification tool by ahsaniqbalsidiqui