关于EasyExcel实现Excel导出功能

        <!--Excel包-->
        <!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>1.1.2-beta5</version>
        </dependency>

@Test
    public void  ExportTest() throwsIOException {
        //指定文件输出位置
        OutputStream outputStream =new FileOutputStream("H:/excel/file/myexcel3.xlsx");
        ExcelWriter excelWriter =EasyExcelFactory.getWriter(outputStream);
        //将要输出的内容填充到Sheet里
        Sheet sheet =new Sheet(1,0,ExcelModel.class);
        //设置sheet表名
        sheet.setSheetName("my_three_excel");
        /*** 写数据到Write上下文中
         * 第一个参数：要写入的内容
         * 第二个参数：要写入的sheet目标
         */excelWriter.write(createModelList2(),sheet);
        excelWriter.finish();
        outputStream.close();
    }

@Data
public class ExcelMode extendsBaseRowModel {
    @ExcelProperty(value = "姓名" ,index = 0)
    privateString  userName;
    @ExcelProperty(value = "年龄" ,index = 1)
    privateString age;
    @ExcelProperty(value = "住址" ,index = 2)
    privateString address;
}

private List<ExcelMode>createModelList (){
        List<ExcelMode> list = new ArrayList<>();
        for(int i=0; i<20;i++){
            ExcelMode excelMode = newExcelMode();
            excelMode.setUserName("哒哒"+i);
            excelMode.setAge("22");
            excelMode.setAddress("广西");
            list.add(excelMode);
        }
        returnlist;
    }

@Data
public class ExcelModel2 extendsBaseRowModel {
    @ExcelProperty(value = {"name","name"},index = 0)
    privateString name;
    @ExcelProperty(value ={"age","age"},index = 1)
    privateString age;
    @ExcelProperty(value={"cash_value","高"},index = 2)
    privateString cashvalue_high ;
    @ExcelProperty(value={"cash_value","中"},index = 3)
    privateString cashvalue_during ;
    @ExcelProperty(value={"cash_value","低"},index = 4)
    privateString cashvalue_low ;

}