java 从EXCEL导入到系统

package org.fh.util;

import java.io.File;
import java.io.FileInputStream;
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;
import org.fh.entity.PageData;


/**
 * 说明：从EXCEL导入到系统
 * 作者：FH Admin
 * from：fhadmin.cn
 */
public class ObjectExcelRead {

  /**
   * @param filepath //文件路径
   * @param filename //文件名
   * @param startrow //开始行号
   * @param startcol //开始列号
   * @param sheetnum //sheet
   * @return list
   */
  public static List<Object> readExcel(String filepath, String filename, int startrow, int startcol, int sheetnum) {
    List<Object> varList = new ArrayList<Object>();

    try {
      File target = new File(filepath, filename);
      FileInputStream fi = new FileInputStream(target);
      HSSFWorkbook wb = new HSSFWorkbook(fi);
      HSSFSheet sheet = wb.getSheetAt(sheetnum);          //sheet 从0开始
      int rowNum = sheet.getLastRowNum() + 1;           //取得最后一行的行号

      for (int i = startrow; i < rowNum; i++) {         //行循环开始
        
        PageData varpd = new PageData();
        HSSFRow row = sheet.getRow(i);              //行
        int cellNum = row.getLastCellNum();           //每行的最后一个单元格位置

        for (int j = startcol; j < cellNum; j++) {        //列循环开始
          
          HSSFCell cell = row.getCell(Short.parseShort(j + ""));
          varpd.put("var"+j, cell.toString());
          
        }
        varList.add(varpd);
      }

    } catch (Exception e) {
      System.out.println(e);
    }
    
    return varList;
  }
}