| | |
|---|
| | | return ""; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public static void downloadExcel(HttpServletResponse response, String fileName, String sheetName, List<Converter> list){ |
|---|
| | | if(CollectionUtils.isEmpty(list)){ |
|---|
| | | return; |
|---|
| | | } |
|---|
| | | try{ |
|---|
| | | response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); |
|---|
| | | response.setCharacterEncoding("utf-8"); |
|---|
| | | fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20"); |
|---|
| | | response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); |
|---|
| | | EasyExcel.write(response.getOutputStream(), list.get(0).getClass()).sheet(sheetName).doWrite(list); |
|---|
| | | }catch (Exception e){ |
|---|
| | | log.error("导出{}异常",sheetName,e); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
