I am getting the following exception while trying to write an .xlsx file using Apache POI
NoClassDefFoundError: javax/xml/stream/XMLStreamException
Here's the Code Snippet:-
XSSFWorkbook wb = new XSSFWorkbook();
Sheet sheet = wb.createSheet();
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue(100);
FileOutputStream fileOut = new FileOutputStream("D:\\workspace\\April\\Excel Test\\workbook.xlsx");
wb.write(fileOut);
fileOut.close();
I have the following jars included
Please let me know what i am doing wrong here or i am missing something.
You're missing the stax API jar
If you look at the POI Components page you'll see that the ooxml-schemas jar depends on a STAX API jar (most typically provided by stax-api-1.0.1.jar
)
Look in your POI binary download, and in the ooxml-lib
directory you'll see the jar you need. Alternately, if you use Maven, it'll download the dependency for you
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With