基于SSM的Excel的导入导出(EasyExcel)
1、导入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.0-beta2</version>
</dependency>
2、编写代码
1、持久类
@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;
}
2、代码
@RequestMapping("/export")
public String expo1(){
List<Orders> list=service.findAccount();
EasyExcel.write("D:\\"+"药品售卖信息清单.xls",Orders.class).sheet("信息清单").doWrite(list);
return "redirect:/drug/see";
}