Examples with ExcelUtil com.ruoyi.common.utils.poi.ExcelUtil used on opensource projects

Example 1 with ExcelUtil

use of com.ruoyi.common.utils.poi.ExcelUtil in project hocassian-media-matrix by hokaso.

the class SysUserController method importData.

@Log(title = "用户管理", businessType = BusinessType.IMPORT)
@PreAuthorize("@ss.hasPermi('system:user:import')")
@PostMapping("/importData")
public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception {
    ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
    List<SysUser> userList = util.importExcel(file.getInputStream());
    LoginUser loginUser = tokenService.getLoginUser(ServletUtils.getRequest());
    String operName = loginUser.getUsername();
    String message = userService.importUser(userList, updateSupport, operName);
    return AjaxResult.success(message);
}