Java操作EasyExcel

记录一下Java操作EasyExcel 

1. maven

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

2. 实体类

public class DemoData {
    
    @ExcelProperty(value = "学生编号",index = 0)
    private Integer sno;
    @ExcelProperty(value = "学生姓名",index = 1)
    private String sname;
//省略get/set方法
}

3. 对Excel的写入操作

public class WriteExcel {
    String file_name = "C:\\Users\\XINYIMCN\\Desktop\\1235.xlsx";
    @Test
    public void startdemo(){
        EasyExcel.write(file_name,DemoData.class).sheet("学生列表").doWrite(getData());
    }
        private static List<DemoData> getData(){
            List<DemoData> list = new ArrayList<>();
            for (int i = 0; i < 10; i++) {
                DemoDat