//該類有main方法，主要負(fù)責(zé)運(yùn)行程序，同時(shí)該類中也包含了用poi讀取Excel(2003版) import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.List; 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;  /** *  * @author Hongten</br> *  *  */public class XlsMain {   public static void main(String[] args) throws IOException {    XlsMain xlsMain = new XlsMain();    XlsDto xls = null;    List<XlsDto> list = xlsMain.readXls();         try {      XlsDto2Excel.xlsDto2Excel(list);    } catch (Exception e) {      e.printStackTrace();    }    for (int i = 0; i < list.size(); i++) {      xls = (XlsDto) list.get(i);      System.out.println(xls.getXh() + "  " + xls.getXm() + "  "          + xls.getYxsmc() + "  " + xls.getKcm() + "  "          + xls.getCj());    }   }   /**   * 讀取xls文件內(nèi)容   *    * @return List<XlsDto>對(duì)象   * @throws IOException   *       輸入/輸出(i/o)異常   */  private List<XlsDto> readXls() throws IOException {    InputStream is = new FileInputStream("pldrxkxxmb.xls");    HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);    XlsDto xlsDto = null;    List<XlsDto> list = new ArrayList<XlsDto>();    // 循環(huán)工作表Sheet    for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {      HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);      if (hssfSheet == null) {        continue;      }      // 循環(huán)行Row      for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {        HSSFRow hssfRow = hssfSheet.getRow(rowNum);        if (hssfRow == null) {          continue;        }        xlsDto = new XlsDto();        // 循環(huán)列Cell        // 0學(xué)號(hào) 1姓名 2學(xué)院 3課程名 4 成績(jī)        // for (int cellNum = 0; cellNum <=4; cellNum++) {        HSSFCell xh = hssfRow.getCell(0);        if (xh == null) {          continue;        }        xlsDto.setXh(getValue(xh));        HSSFCell xm = hssfRow.getCell(1);        if (xm == null) {          continue;        }        xlsDto.setXm(getValue(xm));        HSSFCell yxsmc = hssfRow.getCell(2);        if (yxsmc == null) {          continue;        }        xlsDto.setYxsmc(getValue(yxsmc));        HSSFCell kcm = hssfRow.getCell(3);        if (kcm == null) {          continue;        }        xlsDto.setKcm(getValue(kcm));        HSSFCell cj = hssfRow.getCell(4);        if (cj == null) {          continue;        }        xlsDto.setCj(Float.parseFloat(getValue(cj)));        list.add(xlsDto);      }    }    return list;  }   /**   * 得到Excel表中的值   *    * @param hssfCell   *      Excel中的每一個(gè)格子   * @return Excel中每一個(gè)格子中的值   */  @SuppressWarnings("static-access")  private String getValue(HSSFCell hssfCell) {    if (hssfCell.getCellType() == hssfCell.CELL_TYPE_BOOLEAN) {      // 返回布爾類型的值      return String.valueOf(hssfCell.getBooleanCellValue());    } else if (hssfCell.getCellType() == hssfCell.CELL_TYPE_NUMERIC) {      // 返回?cái)?shù)值類型的值      return String.valueOf(hssfCell.getNumericCellValue());    } else {      // 返回字符串類型的值      return String.valueOf(hssfCell.getStringCellValue());    }  } }

//該類主要負(fù)責(zé)向Excel(2003版)中插入數(shù)據(jù)import java.io.FileOutputStream;import java.io.OutputStream;import java.util.List; import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRichTextString;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;  public class XlsDto2Excel {   /**   *    * @param xls   *      XlsDto實(shí)體類的一個(gè)對(duì)象   * @throws Exception   *       在導(dǎo)入Excel的過(guò)程中拋出異常   */  public static void xlsDto2Excel(List<XlsDto> xls) throws Exception {    // 獲取總列數(shù)    int CountColumnNum = xls.size();    // 創(chuàng)建Excel文檔    HSSFWorkbook hwb = new HSSFWorkbook();    XlsDto xlsDto = null;    // sheet 對(duì)應(yīng)一個(gè)工作頁(yè)    HSSFSheet sheet = hwb.createSheet("pldrxkxxmb");    HSSFRow firstrow = sheet.createRow(0); // 下標(biāo)為0的行開(kāi)始    HSSFCell[] firstcell = new HSSFCell[CountColumnNum];    String[] names = new String[CountColumnNum];    names[0] = "學(xué)號(hào)";    names[1] = "姓名";    names[2] = "學(xué)院";    names[3] = "課程名";    names[4] = "成績(jī)";    for (int j = 0; j < CountColumnNum; j++) {      firstcell[j] = firstrow.createCell(j);      firstcell[j].setCellValue(new HSSFRichTextString(names[j]));    }    for (int i = 0; i < xls.size(); i++) {      // 創(chuàng)建一行      HSSFRow row = sheet.createRow(i + 1);      // 得到要插入的每一條記錄      xlsDto = xls.get(i);      for (int colu = 0; colu <= 4; colu++) {        // 在一行內(nèi)循環(huán)        HSSFCell xh = row.createCell(0);        xh.setCellValue(xlsDto.getXh());        HSSFCell xm = row.createCell(1);        xm.setCellValue(xlsDto.getXm());        HSSFCell yxsmc = row.createCell(2);        yxsmc.setCellValue(xlsDto.getYxsmc());        HSSFCell kcm = row.createCell(3);        kcm.setCellValue(xlsDto.getKcm());        HSSFCell cj = row.createCell(4);        cj.setCellValue(xlsDto.getCj());(xlsDto.getMessage());      }    }    // 創(chuàng)建文件輸出流，準(zhǔn)備輸出電子表格    OutputStream out = new FileOutputStream("POI2Excel/pldrxkxxmb.xls");    hwb.write(out);    out.close();    System.out.println("數(shù)據(jù)庫(kù)導(dǎo)出成功");  } } 

//該類是一個(gè)實(shí)體類public class XlsDto {  /**   * 選課號(hào)   */  private Integer xkh;  /**   * 學(xué)號(hào)   */  private String xh;  /**   * 姓名   */  private String xm;  /**   * 學(xué)院   */  private String yxsmc;  /**   * 課程號(hào)   */  private Integer kch;  /**   * 課程名   */  private String kcm;  /**   * 成績(jī)   */  private float cj;  public Integer getXkh() {    return xkh;  }  public void setXkh(Integer xkh) {    this.xkh = xkh;  }  public String getXh() {    return xh;  }  public void setXh(String xh) {    this.xh = xh;  }  public String getXm() {    return xm;  }  public void setXm(String xm) {    this.xm = xm;  }  public String getYxsmc() {    return yxsmc;  }  public void setYxsmc(String yxsmc) {    this.yxsmc = yxsmc;  }  public Integer getKch() {    return kch;  }  public void setKch(Integer kch) {    this.kch = kch;  }  public String getKcm() {    return kcm;  }  public void setKcm(String kcm) {    this.kcm = kcm;  }  public float getCj() {    return cj;  }  public void setCj(float cj) {    this.cj = cj;  }   }