Java使用easyExcel操作Excel案例

  这两天一直在玩些小工具,今天整了下阿里巴巴的easyExcel,下面是案例:

import com.alibaba.excel.ExcelReader;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.Sheet;
import com.alibaba.excel.read.context.AnalysisContext;
import com.alibaba.excel.read.event.AnalysisEventListener;
import com.alibaba.excel.support.ExcelTypeEnum;
import org.junit.Test;

import java.io.*;
import java.util.ArrayList;
import java.util.List;

public class TestExcel {

  @Test
    public void testRead() throws FileNotFoundException {
    InputStream inputStream =getInputStream("C:\\Users\\LiGe\\Desktop\\test.xls");
    try {
      ExcelReader reader = new ExcelReader(inputStream, ExcelTypeEnum.XLS, null, new AnalysisEventListener() {
        @Override
        public void invoke(Object o, AnalysisContext analysisContext) {
          System.out.println("当前sheet"+analysisContext.getCurrentSheet().getSheetNo()+ " 当前行：" +