Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  2.  
  3. Part filePart = request.getPart("file");
  4. InputStream fileContent = filePart.getInputStream();
  5.  
  6. File file = new File("D:/temp");
  7. OutputStream outputStream = new FileOutputStream(file);
  8. org.apache.tomcat.util.http.fileupload.IOUtils.copy(fileContent, outputStream);
  9. outputStream.close();
  10. ProcessFile.readFile(file); //to read the file
  11. }
  12.  
  13. public class ProcessFile {
  14.  
  15. public static void readFile(File file) throws IOException{
  16.  
  17. FileInputStream input = new FileInputStream(file);
  18.  
  19. Workbook workbook = new XSSFWorkbook(input);
  20. Sheet firstSheet = workbook.getSheetAt(0);
  21. Iterator<Row> iterator = firstSheet.iterator();
  22.  
  23. while (iterator.hasNext()) {
  24. Row nextRow = iterator.next();
  25. Iterator<Cell> cellIterator = nextRow.cellIterator();
  26. int colNum = 1;
  27.  
  28. Employee emp = new Employee();
  29.  
  30. while (cellIterator.hasNext()) {
  31. Cell cell = cellIterator.next();
  32. String temp = "";
  33.  
  34. cell.setCellType(Cell.CELL_TYPE_STRING);
  35. temp = cell.getStringCellValue();
  36.  
  37. //set employee object
  38.  
  39. switch(colNum){
  40. case 1:
  41. emp.setNumber(Integer.parseInt(temp));
  42. break;
  43. case 2:
  44. emp.setName(temp);
  45. break;
  46. case 3:
  47. emp.setCity(temp);
  48. break;
  49. case 4:
  50. emp.setSalary(Integer.parseInt(temp));
  51. break;
  52. }
  53.  
  54. colNum++;
  55. }
  56. System.out.println(emp.getNumber()+" "+emp.getName()+" "+emp.getCity()+" "+emp.getSalary());
  57.  
  58. }
  59.  
  60. workbook.close();
  61. input.close();
  62. }
  63.  
  64. java.lang.ClassNotFoundException: org.apache.poi.ss.usermodel.Workbook
  65. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)
  66. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)
  67. at BrowseFile.doPost(BrowseFile.java:63)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement