java poi读取excel文件

需要导入poi-3.15.jar
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 java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;

/**批量读取文件夹的excel文件
 * Created by Administrator on 2017/6/12.
 *
 */
public class LoadExcelUtil {
    /**
     * @param strPath
     * @return List<dataAll>
     * @throws Exception
     */
    public static List<dataAll> testReadExcel(String strPath) throws Exception{
        List<dataAll> list = new ArrayList<dataAll>();
        dataAll data = null;
        File file = new File(strPath);//读取文件夹
        if (file.exists()) {
            File[] files = file.listFiles();
            if (files.length == 0) {
                System.out.println("文件夹是空的!");
            }else {
                for (File file2 : files) {
                    System.out.println("读取文件 ：" + file2.getAbsolutePath());
                //创建输入流
                FileInputStream fis = new FileInputStream(new File(file2.getAbsolutePath()));
                //通过构造函数传参
                HSSFWorkbook workbook = new HSSFWorkbook(fis);
                //
                HSSFSheet sheet = workbook.getSheetAt(0);
                //第一行0开始计算
//        HSSFRow row = sheet.getRow(0);

                for (int k = 1; k < sheet.getPhysicalNumberOfRows(); k++) {
                    data = new dataAll();
                    HSSFRow row = sheet.getRow(k);
                    //读取数据
                    HSSFCell cell0 = row.getCell(0);
                    data.setName(cell0.getStringCellValue());

                    HSSFCell cell1 = row.getCell(1);
                    data.setStatus(cell1.getStringCellValue());


                    HSSFCell cell2 = row.getCell(2);
                    data.setPerson(cell2.getStringCellValue());

                    HSSFCell cell3 = row.getCell(3);
                    data.setAddress(cell3.getStringCellValue());

                    HSSFCell cell4 = row.getCell(4);
                    data.setRegister_type(cell4.getStringCellValue());

                    HSSFCell cell5 = row.getCell(5);
                    data.setDate(cell5.getStringCellValue());

                    HSSFCell cell6 = row.getCell(6);
                    data.setDepart(cell6.getStringCellValue());

                    HSSFCell cell7 = row.getCell(7);
                    data.setDepart_code(cell7.getStringCellValue());

                    HSSFCell cell8 = row.getCell(8);
                    data.setCode(cell8.getStringCellValue());

                    HSSFCell cell9 = row.getCell(9);
                    data.setCreate_time(cell9.getStringCellValue());

                    HSSFCell cell10 = row.getCell(10);
                    data.setUpdate_time(cell10.getStringCellValue());

                    HSSFCell cell11 = row.getCell(11);
                    data.setRN(cell11.getStringCellValue());
                    list.add(data);
                }
                workbook.close();
                fis.close();
                }
            }
        }
        return list;
    }
}

比较详细的blog http://blog.csdn.net/huazhangena/article/details/7587731