基于SSM的Excel的导入导出（EasyExcel）

  com.alibaba
  easyexcel
  2.2.0-beta2

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Orders implements Serializable {

    @ExcelProperty("编号")
    private int oid;
    @ExcelIgnore
    private String id;
    @ExcelProperty("顾客姓名")
    private String name;
    @ExcelProperty("性别")
    private String gender;
    @ExcelProperty("年龄")
    private Integer age;
    @ExcelProperty("地址")
    private String address;
    @ExcelProperty("QQ")
    private String qq;
    @ExcelProperty("Email")
    private String email;
    @ExcelIgnore
    private int did;
    @ExcelProperty("药名")
    private String dname;
    @ExcelProperty("药类")
    private String dsort;
    @ExcelProperty("价格")
    private double dprice;
    @ExcelProperty("出厂商")
    private String dproducer;
    @ExcelProperty("售卖数量")
    private int anumber;
    @ExcelProperty("售卖日期")
    private String adate;

}

@RequestMapping("/export")
public String expo1(){
    List list=service.findAccount();
    EasyExcel.write("D:\"+"药品售卖信息清单.xls",Orders.class).sheet("信息清单").doWrite(list);
    return "redirect:/drug/see";
}