使用java导出Excel.docx

package com.ireport;import java.io.IOException;import java.io.OutputStream;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.LinkedList;import java.util.List;import javax.faces.context.FacesContext;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import mons.lang.StringUtils;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFFont;import org.apache.poi.hssf.usermodel.HSSFRichTextString;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.hssf.util.CellRangeAddress;import org.apache.poi.hssf.util.HSSFColor;import com.bean.ReportBean;/** * 创建报表和样式 * @author Administrator * */public class ReportActionHandler {private static ReportActionHandler instance = new ReportActionHandler();private HSSFWorkbook workbook;private HSSFCellStyle styleEven; //偶数行样式private HSSFCellStyle styleOdd; //奇数行样式private HSSFCellStyle styleTitle;//标题样式private HSSFCellStyle styleColTitle;//列标题样式private ReportActionHandler(){}public static ReportActionHandler getInstance(){return instance;}/** * 生成报表 * @param list */public void buildExcelReport(ListReportBean list){ workbook = new HSSFWorkbook();// 创建一个Excel文件 ReportActionHandler.getInstance().initCellStyle(); workbook.createSheet();// 创建一个Excel的Sheet String reportTitlt = null;//Excel文档标题 ListString colTitle = null;//Excel第一列标题 buildExcelReportTemplate(reportTitlt,colTitle); ListReportBean data = list;//Excel封装的数据 buildExcelReportData(data); String footRowMessage = null;//Excel最后一列的内容 buildExcelReportFootRow(footRowMessage); setSheetHeight(); String fileName = null;//网络文件名称 sendExcelReport(fileName);}/** * 构建excel报表模板 * @param workbook * @param sheet * @param reportTitle 报表标题 * @param colTitle 列标题 */private void buildExcelReportTemp