Cannot implement xlsx file extension in apache POI

Question

I cannot make an XSSF object in java with the apache POI. I have a list of file directories saved as an array of strings as "list[]". xls (HSSF) are working just fine with no errors.

Using the following code:

String s = list[i]; //line 205
InputStream input = new FileInputStream(s);  //line 206 
Workbook wb = new XSSFWorkbook(input); //line 207

I get the error:

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.setSaveAggressiveNamespaces()Lorg/apache/xmlbeans/XmlOptions;
    at org.apache.poi.POIXMLDocumentPart.<clinit>(POIXMLDocumentPart.java:56)
    at FileTest.skim(FileTest.java:207)
    at FileTest.main(FileTest.java:125)

Jonas Adler · Accepted Answer · 2012-05-06 00:13:04Z

1

This seems like a library mix-up. I just checked with xmlbeans-2.3.0 and it has the method you're missing. Make sure you have the proper dependencies for the POI version you're using.

answered May 6, 2012 at 0:13

Jonas Adler

9145 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nick Over a year ago

turns out i was just missing xmlbeans jar file. Not sure how i overlooked that, ha.

Nick Over a year ago

Update** It also turns out that the newest version of xmlbeans should be applied to the apache poi. the 2.3.0 version works for some things, but i highly recommend downloading the current version for future apache poi programming (2.5.0)

Collectives™ on Stack Overflow

Cannot implement xlsx file extension in apache POI

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related