【无标题】

• Spring boot中怎样把Excel表格数据导出导入
• • 导出与导入
  • • 导出
    • 导入

@ResponseExcel
@GetMapping("/export")
@PreAuthorize("@pms.hasPermission('bidding_materialbilllist_export')")
public List export(MaterialBillList materialBillList) {
	return materialBillListService.list(Wrappers.query(materialBillList));
}

 * 导入物料
 *
 * @param excelVOList   物料列表
 * @param bindingResult 错误信息列表
 * @return R
 */
@PostMapping("/import")
@PreAuthorize("@pms.hasPermission('bidding_materialbilllist_export')")
public R importUser(@RequestExcel List excelVOList, BindingResult bindingResult) {
	System.err.println("BBAID:" + this.bbaId + "-----MBMID:" + matMap.get(SecurityUtils.getUser().getUsername()));
	return materialBillListService.importMaterial(excelVOList, bindingResult, this.bbaId, Long.valueOf(matMap.get(SecurityUtils.getUser().getUsername())));
}