I am trying to read data in an excel spreadsheet row by row and create a record for each row. Each row will have many cells containing data of types text, number and images. There can be multiple images and images can be placed over the cells or embedded within the cell.

Recently, I have updated the Apache POI from 3.17 to 4.1.2 because of the vulnerability name XSSFExportToXml XXE, namely “CVE-2019-12415”. Fortunately, I don’t have to rewrite any code. But the excel exmported are all empty. Maybe I should ask for help here before I have to read the official documents for such a specific problem. Is there anyone who has faced the same problem? Thank you if you can tell me about how you solve it.

I have an xlsx file with Autofilter inside. Does exist any possibilty to remove it with Apache POI library? sheet.setAutoFilter(CellRangeAddress) just creates it, but does not remove.

Is it possble to actually get at the macro code as text, not just the entire project as a Blob.