java 导入到EXCEL表格
程序员文章站
2022-06-14 19:29:25
...
package com.fh.util; 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.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.HorizontalAlignment; import org.apache.poi.ss.usermodel.VerticalAlignment; import org.apache.poi.ss.usermodel.Workbook; import org.springframework.web.servlet.view.document.AbstractXlsView; import com.fh.util.PageData; import com.fh.util.Tools; /** * 说明:导入到EXCEL * 作者:FH Admin * from:fhadmin.cn */ public class ObjectExcelView extends AbstractXlsView{ @Override protected void buildExcelDocument(Map<String, Object> model, Workbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception { // TODO Auto-generated method stub Date date = new Date(); String filename = Tools.date2Str(date, "yyyyMMddHHmmss"); HSSFSheet sheet; response.setContentType("application/octet-stream"); response.setHeader("Content-Disposition", "attachment;filename="+filename+".xls"); HSSFWorkbook book = (HSSFWorkbook) workbook; sheet = book.createSheet("sheet1"); List<String> titles = (List<String>) model.get("titles"); int len = titles.size(); HSSFCellStyle headerStyle = book.createCellStyle(); //标题样式 headerStyle.setAlignment(HorizontalAlignment.CENTER); headerStyle.setVerticalAlignment(VerticalAlignment.CENTER); HSSFFont headerFont = book.createFont(); //标题字体 headerFont.setBold(true); headerFont.setFontHeightInPoints((short)11); headerStyle.setFont(headerFont); short height=25*20; HSSFRow row = sheet.createRow(0); for(int i=0; i<len; i++){ //设置标题 String title = titles.get(i); row.setRowStyle(headerStyle); row.createCell(i).setCellValue(title); } sheet.getRow(0).setHeight(height); HSSFCellStyle contentStyle = book.createCellStyle(); //内容样式 contentStyle.setAlignment(HorizontalAlignment.CENTER); List<PageData> varList = (List<PageData>) model.get("varList"); int varCount = varList.size(); for(int i=0; i<varCount; i++){ PageData vpd = varList.get(i); HSSFRow rows = sheet.createRow(i+1); for(int j=0;j<len;j++){ String varstr = vpd.getString("var"+(j+1)) != null ? vpd.getString("var"+(j+1)) : ""; rows.setRowStyle(contentStyle); rows.createCell(j).setCellValue(varstr); } } } }