Ruoyi 导出
Domain
@Excel(name = "学生编号",cellType = Excel.ColumnType.NUMERIC)//需要导出的主键
private int id;
@Excel(name = "学生姓名")//需要导出的字段
private String name;
@Excel(name = "年龄")
private int age;
@Excel(name = "推荐")
private int success;
@Excel(name = "TTid")
private int ttid;
Controller
/**
* 导出
*/
@Log(title = "学生", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:student:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(Student student)
{
List<Student> list = studentService.selectStudentList(student);
ExcelUtil<Student> util = new ExcelUtil<Student>(Student.class);
return util.exportExcel(list, "学生");
}
Html
<a class="btn btn-warning" onclick="$.table.exportExcel()" shiro:hasPermission="system:student:export">
<i class="fa fa-download"></i> 导出
</a>