java lang ClassNotFoundException org apache xmlbeans XmlObject Error

Question

I am getting following error       Exception in thread  main  java lang NoClassDefFoundError  org apache xmlbeans XmlObject       at OrderBook WriteToExcelSheet CreateOutPutFile WriteToExcelSheet java 20        at OrderBook MainMethod main MainMethod java 71    I looked for the reasons for this error online but couldn t find why I am getting it   I have included the following jar files  poi-3 9-20121203 jar   poi-excelant-3 9-20121203 jar  poi-examples-3 9-20121203 jar  poi-ooxml-3 9-20121203 jar  poi-ooxml-schemas-3 9-20121203 jar  poi-scratchpad-3 9-20121203 jar   Code    public class WriteToExcelSheet       public static Map  lt  Integer  Object    gt  data   new TreeMap  lt  Integer  Object    gt          public static void CreateOutPutFile             XSSFWorkbook workbook   new XSSFWorkbook            XSSFSheet sheet   workbook createSheet  Orderbook Stats              This data needs to be written  Object              Iterate over data and write to sheet         Set  lt  Integer  gt  keyset   data keySet           int rownum   0          for  Integer key  keyset                Row row   sheet createRow rownum                 Object   objArr   data get key               int cellnum   0              for  Object obj  objArr                    Cell cell   row createCell cellnum                     if  obj instanceof String  cell setCellValue  String  obj                   else if  obj instanceof Integer  cell setCellValue  Integer  obj                                   try                 Write the workbook in file system             System out println  OutPutStats xlsx writing                                              FileOutputStream out   new FileOutputStream new File  FileLocation o xlxs                 workbook write out               out close                System out println  OutPutStats xlsx written successfully on disk               catch  Exception e                e printStackTrace

User · Answer

I faced a similar situation  so i replaced all the external jar files poi-bin-3 17-20170915  and make sure you add other jar files present in lib and ooxml-lib folders    Hope this helps

User · Answer

I was working with talend V7 3 1 and I had poi version  quot 4 1 0 quot  and including xml-beans from the list of dependencies didnt fix my problem  i e  2 3 0 and 2 6 0   It was fixed by downloading the jar  quot xmlbeans-3 0 1 jar quot  and adding it to the project

User · Answer

For all that you add xmlbeans-2 3 0 jar and it is not working you must use HSSFWorkbook instead of XSSFWorkbook after add jar For instance       Workbook workbook   new HSSFWorkbook        Sheet listSheet   workbook createSheet  Kisi Listesi         int rowIndex   0      for  KayitParam kp   kayitList            Row row   listSheet createRow rowIndex             int cellIndex   0          row createCell cellIndex    setCellValue kp getAd             row createCell cellIndex    setCellValue kp getSoyad             row createCell cellIndex    setCellValue kp getEposta             row createCell cellIndex    setCellValue kp getCinsiyet             row createCell cellIndex    setCellValue kp getDogumtarihi             row createCell cellIndex    setCellValue kp getTahsil                try           ByteArrayOutputStream baos   new ByteArrayOutputStream            workbook write baos           AMedia amedia   new AMedia  Kisiler xls    xls                    application file   baos toByteArray             Filedownload save amedia           baos close          catch  Exception e            e printStackTrace

User · Answer

You have to include one more jar    xmlbeans-2 3 0 jar   Add this and try   Note  It is required for the files with  xlsx formats only  not for just  xls formats

User · Answer

When trying to translate Excel file with  xlsx suffix  you need to add additional jar  xmlbeansxxx jar  xxxx  is version  such as xmlbeans-2 3 0 jar

User · Answer

you have to include two more jar files   xmlbeans-2 3 0 jar and dom4j-1 6 1 jar  Add try it will work   Note  It is required for the files with  xlsx formats only  not for just  xlt formats

User · Answer

You need to include xmlbeans-xxx jar and if you have downloaded the POI binary zip  you will get the xmlbeans-xxx jar in ooxml-lib folder  eg   poi-3 11 ooxml-lib   This jar is used for XML binding which is applicable for  xlsx files

[java] java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlObject Error

Examples related to java