首先加入Excel的依赖,本例中我们用apache的poi:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
后台导出Excel的Controller接口代码:
import org.apache.poi.hssf.usermodel.*;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@Controller
public class ExcelController {
/**
* Excel表格导出接口
* http://localhost:8080/ExcelDownload
* @param response response对象
* @throws IOException 抛IO异常
*/
@RequestMapping("/ExcelDownload")
public void excelDownload(HttpServletResponse response) throws IOException {
//表头数据
String[] header = {"ID", "姓名", "性别", "年龄", "地址", "分数"};
//数据内容
String[] student1 = {"1", "小红", "女", "23", "成都青羊区", "96"};
String[] student2 = {"2", "小强", "男", "26", "成都金牛区", "91"};
String[] student3 = {"3", "小明", "男", "28", "成都武侯区", "90"};
//声明一个工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
//生成一个表格,设置表格名称为"学生表"
HSSFSheet sheet = workbook.createSheet("学生表");
//设置表格列宽度为10个字节
sheet.setDefaultColumnWidth(10);
//创建第一行表头
HSSFRow headrow = sheet.createRow(0);
//遍历添加表头(下面模拟遍历学生,也是同样的操作过程)
for (int i = 0; i < header.length; i++) {
//创建一个单元格
HSSFCell cell = headrow.createCell(i);
//创建一个内容对象
HSSFRichTextString text = new HSSFRichTextString(header[i]);
//将内容对象的文字内容写入到单元格中
cell.setCellValue(text);
}
//模拟遍历结果集,把内容加入表格
//模拟遍历第一个学生
HSSFRow row1 = sheet.createRow(1);
for (int i = 0; i < student1.length; i++) {
HSSFCell cell = row1.createCell(i);
HSSFRichTextString text = new HSSFRichTextString(student1[i]);
cell.setCellValue(text);
}
//模拟遍历第二个学生
HSSFRow row2 = sheet.createRow(2);
for (int i = 0; i < student2.length; i++) {
HSSFCell cell = row2.createCell(i);
HSSFRichTextString text = new HSSFRichTextString(student2[i]);
cell.setCellValue(text);
}
//模拟遍历第三个学生
HSSFRow row3 = sheet.createRow(3);
for (int i = 0; i < student3.length; i++) {
HSSFCell cell = row3.createCell(i);
HSSFRichTextString text = new HSSFRichTextString(student3[i]);
cell.setCellValue(text);
}
//准备将Excel的输出流通过response输出到页面下载
//八进制输出流
response.setContentType("application/octet-stream");
//这后面可以设置导出Excel的名称,此例中名为student.xls
response.setHeader("Content-disposition", "attachment;filename=student.xls");
//刷新缓冲
response.flushBuffer();
//workbook将Excel写入到response的输出流中,供页面下载
workbook.write(response.getOutputStream());
}
}
然后访问接口,就会自动下载下来了。仅供学习,欢迎交流!!!