Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2014
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.09 KB | None | 0 0
  1. Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject
  2. at ExcelReader.main(ExcelReader.java:32)
  3. Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlObject
  4. at java.net.URLClassLoader$1.run(Unknown Source)
  5. at java.net.URLClassLoader$1.run(Unknown Source)
  6. at java.security.AccessController.doPrivileged(Native Method)
  7. at java.net.URLClassLoader.findClass(Unknown Source)
  8. at java.lang.ClassLoader.loadClass(Unknown Source)
  9. at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
  10. at java.lang.ClassLoader.loadClass(Unknown Source)
  11. ... 1 more
  12.  
  13. import java.io.File;
  14. import java.io.FileInputStream;
  15. import javax.swing.text.html.HTMLDocument.Iterator;
  16. import org.apache.poi.hssf.usermodel.HSSFSheet;
  17. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  18. import org.apache.poi.ss.usermodel.Cell;
  19. import org.apache.poi.ss.usermodel.Row;
  20. import org.apache.poi.xssf.usermodel.XSSFSheet;
  21. import java.util.*;
  22. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  23. /**
  24. * @author mohammad hosein
  25. *
  26. */
  27. public class ExcelReader {
  28.  
  29. /**
  30. * @param args
  31. */
  32. public static void main(String[] args) {
  33. try
  34. {
  35. FileInputStream file = new FileInputStream(new File("E:\test.xlsx"));
  36.  
  37. //Get the workbook instance for XLS file
  38. XSSFWorkbook workbook = new XSSFWorkbook (file);
  39.  
  40. //Get first sheet from the workbook
  41. XSSFSheet sheet = workbook.getSheetAt(0);
  42.  
  43. //Get iterator to all the rows in current sheet
  44. java.util.Iterator<Row> rowIterator = sheet.iterator();
  45.  
  46. while(rowIterator.hasNext())
  47. {
  48. Row row = rowIterator.next();
  49. java.util.Iterator<Cell> cellIterator = row.cellIterator();
  50.  
  51. while(cellIterator.hasNext())
  52. {
  53. Cell cell = cellIterator.next();
  54. System.out.print(cell.getStringCellValue() + "t");
  55. }
  56. System.out.println("");
  57. }
  58. }
  59. catch(Exception e)
  60. {
  61. System.out.println("EROR!");
  62. }
  63.  
  64. //Get iterator to all cells of current row
  65.  
  66. }
  67.  
  68. public class ClassNotFoundException
  69. extends ReflectiveOperationException
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement