解析excel文件--2003

//解析excel文件
  String path = "src/main/webapp/importTemplate/template.xls";
  FileInputStream fis = new FileInputStream(path);
  Workbook workBook = Workbook.getWorkbook(fis);
  Sheet sheet = workBook.getSheet(0);
  int rows = sheet.getRows();
  int columns = sheet.getColumns();
  System.out.println("columns-->"+columns);
  System.out.println("rows-->"+rows);
  
  for(int i=0; i<rows; i++) {
   Cell[] cell = sheet.getRow(i);
   for(int j=0; j<columns; j++) {
    System.out.print(cell[j].getContents()+"  ");
   }
   System.out.println();
  }

 

相关的包可以到网上去下载