yc_easypoi excel数据导入

easypoi

gitee clone

     https://gitee.com/lemur/easypoi-test.git

ExcelMapImportTest

package cn.afterturn.easypoi.test.excel.read;

import java.io.File;
import java.util.Date;
import java.util.List;
import java.util.Map;

import org.junit.Assert;
import org.junit.Test;

import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.afterturn.easypoi.util.PoiPublicUtil;

/**
 * Map导入测试
 * @author JueYue
 *   2015年6月21日 下午10:56:03
 */
public class ExcelMapImportTest {

    @Test
    public void mapTest() {

        ImportParams params = new ImportParams();
        params.setTitleRows(1);
        params.setHeadRows(1);
        params.setDataHandler(new MapImportHandler());
        long start = new Date().getTime();
        List<Map<String, Object>> list = ExcelImportUtil.importExcel(
            new File(FileUtilTest.getWebRootPath("import/check.xls")), Map.class, params);
        for (int i = 0; i < list.size(); i++) {
            System.out.println(list.get(i));
        }
        System.out.println(new Date().getTime() - start);
        Assert.assertEquals(20,list.size());


    }

}