Java用poi读取excel文件

package POI;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
 
public class ReadExcel {
 public static void main(String[] args) {
  try {
   InputStream input = new FileInputStream("D://test.xls");
   POIFSFileSystem fs = new POIFSFileSystem(input);
   HSSFWorkbook wb = new HSSFWorkbook(fs);
   HSSFSheet sheet = wb.getSheetAt(0);

    

   Iterator rows = sheet.rowIterator();

   while (rows.hasNext()) {
    HSSFRow row = (HSSFRow) rows.next();
    System.out.println("Row #" + row.getRowNum());

 

    Iterator cells = row.cellIterator();
    while (cells.hasNext()) {
       HSSFCell cell = (HSSFCell) cells.next();
       System.out.println("Cell #" + cell.getCellNum());

       switch (cell.getCellType()) {
          case HSSFCell.CELL_TYPE_NUMERIC:
              System.out.println(cell.getNumericCellValue());
              break;
          case HSSFCell.CELL_TYPE_STRING:
              System.out.println(cell.getStringCellValue());
              break;
          case HSSFCell.CELL_TYPE_BOOLEAN:
             System.out.println(cell.getBooleanCellValue());
             break;
          case HSSFCell.CELL_TYPE_FORMULA:
              System.out.println(cell.getCellFormula());
              break;
         default:
              System.out.println("unsuported sell type");
          break;
     }
    }
   }
  } catch (IOException ex) {
   ex.printStackTrace();
  }
 }

}