Pomelo Lee workspace

<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>easyexcel</artifactId>
  <version>1.0.3</version>
</dependency>

package com.pomelolee.xls;
 
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
 
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.Sheet;
import com.alibaba.excel.metadata.Table;
import com.alibaba.excel.support.ExcelTypeEnum;
 
/**
 * @author pomelolee
 *
 * @time 2018年12月19日 下午2:42:18
 */
public class EasyXls {
 
	public static void main(String[] args) throws Exception {
		writeWithoutHead();
	}
 
	public static void writeWithoutHead() throws Exception {
		try (OutputStream out = new FileOutputStream("E://withHead.xlsx");) {
			ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLSX);
			Sheet sheet1 = new Sheet(1, 0);
			sheet1.setSheetName("表一");
			List<List<String>> head = new ArrayList<List<String>>();
			List<String> headCoulumn1 = new ArrayList<String>();
			List<String> headCoulumn2 = new ArrayList<String>();
			List<String> headCoulumn3 = new ArrayList<String>();
			headCoulumn1.add("第一列");
			headCoulumn2.add("第二列");
			headCoulumn3.add("第三列");
			head.add(headCoulumn1);
			head.add(headCoulumn2);
			head.add(headCoulumn3);
			Table table = new Table(1);
			table.setHead(head);
			for (int i = 0; i < 10; i++) {
				writeDataToTable(table, sheet1, writer);
			}
			Sheet sheet2 = new Sheet(2, 0);
			sheet2.setSheetName("表二");
			writeDataToTable(table, sheet2, writer);
			writer.finish();
		}
	}
 
	private static void writeDataToTable(Table table, Sheet sheet, ExcelWriter writer) {
		List<List<String>> data = new ArrayList<>();
		for (int i = 0; i < 100000; i++) {
			List<String> item = new ArrayList<>();
			item.add("item0" + i);
			item.add("item1" + i);
			item.add("item2" + i);
			data.add(item);
		}
		writer.write0(data, sheet, table);
	}
 
}