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;

}

}