poi实战：Excel文件控制与导出详解（含代码）

public class PrintExcelTest {

  public static void main(String[] args) throws Exception {
    File file = new File("User.xls");
    FileInputStream fint = new FileInputStream(file);
    POIFSFileSystem poiFileSystem = new POIFSFileSystem(fint);
    HSSFWorkbook workbook = new HSSFWorkbook(poiFileSystem);
    HSSFSheet sheet = workbook.getSheetAt(0);
    HSSFRow rowTitle = sheet.getRow(0);
    Iterator<HSSFCell> iterTitle = rowTitle.cellIterator();
    while(iterTitle.hasNext()) {
      System.out.print(iterTitle.next().getStringCellValue()+"  ");
    }
    System.out.println("");
    HSSFRow rowUser = sheet.getRow(1);
    Iterator<HSSFCell> iterUser = rowUser.cellIterator();
    while(iterUser.hasNext()) {
      System.out.print(getCell(iterUser.next())+"  ");
    }
    System.out.println("\n");
    System.out.println("出生日期:"+rowUser.getCell((short)3).getDateCellValue().toLocaleString());
  }
  
  public static String getCell(HSSFCell cell) {
    if (cell == null)
      return "";
    switch (cell.getCellType()) {
      case HSSFCell.CELL_TYPE_NUMERIC:
        return cell.getNumericCellValue() + "";
      case HSSFCell.CELL_TYPE_STRING: