XSSFWorkbook,SXSSFWorkbook以及EasyExcel读取Excel文件的比较

 

 同时读取30w数据，比较运行时间及CPU、内存占比

1.EasyExcel

package com.apesource;

import java.util.ArrayList;
import java.util.List;

import com.alibaba.excel.EasyExcel;
import com.apesource.entity.Order;


public class Demo01 {
	public static void main(String[] args) {
		long begin = System.currentTimeMillis();
        // 写入100w
        EasyExcel.write("E:\\test\\demo05.xlsx", Order.class)
                 .sheet("订单列表")
                 .doWrite(data());
        
        long end = System.currentTimeMillis();
        
        System.out.println("EasyExcel读取30w文件共耗时" +(end - begin) +"毫秒");
    }
    
    // 创建100w条订单数据
    private static List<Order> data() {
        List<Order> list = new ArrayList<Order>();
        for (int i = 0; i < 300000; i++) {
            list.add(new Order());
        }
        return list;
    }
}

 

2.XSSFWorkbook

package com.apesource;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Arrays;
im