mhvb
mhvb

Reputation: 31

NoSuchMethodError coming while setting values to Cell using Apache POI

i am getting below error at cell.setCellValue("sdjcb"); can any one please help

Exception in thread "main" java.lang.NoSuchMethodError: 'org.openxmlformats.schemas.officeDocument.x2006.sharedTypes.STXstring org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRst.xgetT()'
at org.apache.poi.xssf.usermodel.XSSFRichTextString.<init>(XSSFRichTextString.java:92)
at org.apache.poi.xssf.usermodel.XSSFCell.setCellType(XSSFCell.java:928)
at org.apache.poi.xssf.usermodel.XSSFCell.setCellTypeImpl(XSSFCell.java:903)[![enter image description here][1]][1]
at org.apache.poi.ss.usermodel.CellBase.setCellType(CellBase.java:57)

[1]: https://i.sstatic.net/Yhz75.png

Upvotes: 1

Views: 1712

Answers (1)

arch2be
arch2be

Reputation: 306

Here is a information about correct version of poi-schemas and version of poi: link. Delete poi-ooxml-schemas-4.1.2.jar and ooxml-schemas-1.4.jar and add poi-ooxm-full.

Upvotes: 1

Related Questions