easyexcel代码

import com.alibaba.excel.EasyExcel; import com.alibaba.excel.cache.MapCache; import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import com.alibaba.excel.support.ExcelTypeEnum; import java.util.Date; import java.util.LinkedHashMap; import java.util.Map; public class Test { static String content = ""; public static void main(String[] args){ String url = "C:\\Users\\cjyou\\Desktop\\a306dedb-3c65-47b5-9c02-d87a61d1ffe2.xlsx"; try { Date time = new Date(); System.out.println("读取开始---"); EasyExcel.read(url, new AnalysisEventListener<LinkedHashMap<Integer, String>>() { @Override public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) { System.out.println("start " + new Date(System.currentTimeMillis())); content += headMap.toString(); System.out.println("end " + new Date(System.currentTimeMillis())); // Iterator<Map.Entry<Integer, String>> iterator = headMap.entrySet().iterator(); // while (iterator.hasNext()) { // String value = iterator.next().getValue(); // if ("null".equals(value) || StringUtil.isEmpty(value)) { // value = " "; // } // String con = value + " "; // content += con; // } } @Override public void invoke(LinkedHashMap<Integer, String> map, AnalysisContext context) { System.out.println("start " + new Date(System.currentTimeMillis())); content += map.toString(); System.out.println("end " + new Date(System.currentTimeMillis())); // Iterator<Map.Entry<Integer, String>> iterator = map.entrySet().iterator(); // while (iterator.hasNext()) { // String value = iterator.next().getValue(); // if ("null".equals(value) || StringUtil.isEmpty(value)) { // value = " "; // } // String con = value + " "; // content += con; // } } @Override public void doAfterAllAnalysed(AnalysisContext context) { System.out.println("读取完毕"); } }).excelType(ExcelTypeEnum.XLSX).ignoreEmptyRow(true).readCache(new MapCache()).sheet().doRead(); Date dateTime2 = new Date(); long da = (dateTime2.getTime() - time.getTime()) / 1000; System.out.println("读取结束---花费时间-" + da + "秒"); Date dateTime3 = new Date(); long da2 = (dateTime3.getTime() - time.getTime()) / 1000; System.out.println("打印结束---花费时间-" + da2 + "秒"); } catch (Exception e) { e.printStackTrace(); } // System.out.println(content); } }