JAVA解析EXCEL(2003和2007)

標籤：

本文參考： 
http://wenku.baidu.com/view/707f07d95022aaea998f0fd1.html 

http://surfingforrest.iteye.com/blog/1709555

http://feitian0127.iteye.com/blog/1152524 

感謝兩位。 

使用的包： 

 
代碼如下： 

import java.util.ArrayList;   import java.io.FileInputStream;  import java.io.IOException;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  import org.apache.poi.xssf.usermodel.XSSFWorkbook;    public class ReadExcel {      public ArrayList<ArrayList<String>> readExcel(String fileName,String path) {          ArrayList<ArrayList<String>> Row =new ArrayList<ArrayList<String>>();                    try {              Workbook workBook = null;              try {              workBook = new XSSFWorkbook(path+"\\"+fileName);              } catch (Exception ex) {              workBook = new HSSFWorkbook(new FileInputStream(path+"\\"+fileName));          }                                           for (int numSheet = 0; numSheet < workBook.getNumberOfSheets(); numSheet++) {                  Sheet sheet = workBook.getSheetAt(numSheet);                  if (sheet == null) {                      continue;                  }                  // 迴圈行Row                  for (int rowNum = 1; rowNum <= sheet.getLastRowNum(); rowNum++) {                      Row row = sheet.getRow(rowNum);                      if (row == null) {                          continue;                      }                                            // 迴圈列Cell                      ArrayList<String> arrCell =new ArrayList<String>();                      for (int cellNum = 0; cellNum <= row.getLastCellNum(); cellNum++) {                          Cell cell = row.getCell(cellNum);                          if (cell == null) {                              continue;                          }                          arrCell.add(getValue(cell));                      }                      Row.add(arrCell);                  }              }          } catch (IOException e) {              System.out.println("e:"+e);          }                return Row;      }        private String getValue(Cell cell) {          if (cell.getCellType() == cell.CELL_TYPE_BOOLEAN) {              return String.valueOf(cell.getBooleanCellValue());          } else if (cell.getCellType() == cell.CELL_TYPE_NUMERIC) {              return String.valueOf(cell.getNumericCellValue());          } else {              return String.valueOf(cell.getStringCellValue());          }      }        public static void main(String[] args) {          ReadExcel s= new ReadExcel();          //ArrayList<ArrayList<String>> row=s.readExcel("TEST.xlsx","D:\\Program Files\\Java");          ArrayList<ArrayList<String>> row=s.readExcel("TEST1.xls","D:\\Program Files\\Java");          System.out.println("size:"+row.size());          for (ArrayList<String> cell : row) {              for (String str : cell) {                  System.out.println(str);                  }              }      }  }  

JAVA解析EXCEL(2003和2007)