layui 导出Excel
开发工具:eclipse、 mysql
技术架构:javaSSM、 layui
工具类
package com.hezuo.utils;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.web.servlet.view.document.AbstractExcelView;
public class ExcelExportData extends AbstractExcelView{
private String[] titles;
// 传入指定的标题头
public ExcelExportData(String[] titles) {
this.titles = titles;
}
@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
HttpServletResponse response) throws Exception {
//获取数据
@SuppressWarnings("unchecked")
List<Map<String, String>> list=(List<Map<String, String>>) model.get("excelList");
//在workbook添加一个sheet
HSSFSheet sheet=workbook.createSheet();
sheet.setDefaultColumnWidth(15);
HSSFCell cell=null;
//遍历标题
for (int i = 0; i