SpringBoot 数据库表导出到Excel文件

SpringBoot 数据库表导出到Excel文件

所需pom文件

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.12</version>
</dependency>

后台Controller层代码如下：

@RequestMapping("getExcel")
private void getExcel(HttpServletResponse response) throws IOException {
String fileName = "新闻内容.xls";
response.setContentType("application/excel");
response.setHeader("Content-disposition", "attachment;filename=" + fileName + ";filename*=utf-8''" + URLEncoder.encode(fileName, "UTF-8"));
response.flushBuffer();
List <Usera> user = userDao.findUser();
String aa = "新闻表";
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
int rowNum = 0;
// 添加标题
String[] headers = {"标题", "版块", "作者", "创建时间", "内容"};
HSSFRow row = sheet.createRow(rowNum);
for (int i = 0; i < headers.length; i++) {
HSSFCell cell = row.createCell(i);
HSSFRichTextString text = new HSSFRichTextString(headers[i]);
cell.setCellValue(text);
}
//添加数据
for (Usera topic : user) {
rowNum++;
HSSFRow row1 = sheet.createRow(rowNum);
row1.createCell(0).setCellValue(topic.getName());
row1.createCell(1).setCellValue(topic.getAge());
workbook.write(response.getOutputStream());
}
}

前台html页面代码如下：

<table border="0" style="margin-top:4px; margin-left: 18px">
            <tr>
                <td><a href="#" class="easyui-linkbutton" onclick="downloadfile();">数据导出</a></td>
            </tr>
</table>

前台js页面代码如下：

function downloadfile(){
        window.location.href="/getExcel";
    }