使用java导出Excel

《使用java导出Excel》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、packagecom.ireport;importjava.io.IOException;importjava.io.OutputStream;importjava.text.DateFormat;importjava.text.SimpleDateFormat;importjava.util.ArrayList;importjava.util.Date;importjava.util.LinkedList;importjava.util.List;importjavax.faces.context.Face

2、sContext;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importorg.apache.commons.lang.StringUtils;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.h

3、ssf.usermodel.HSSFFont;importorg.apache.poi.hssf.usermodel.HSSFRichTextString;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.hssf.util.CellRange

4、Address;importorg.apache.poi.hssf.util.HSSFColor;importcom.bean.ReportBean;/***创建报表和样式*@authorAdministrator**/publicclassReportActionHandler{privatestaticReportActionHandlerinstance=newReportActionHandler();privateHSSFWorkbookworkbook;privateHSSFCellStylest

5、yleEven;//偶数行样式privateHSSFCellStylestyleOdd;//奇数行样式privateHSSFCellStylestyleTitle;//标题样式privateHSSFCellStylestyleColTitle;//列标题样式privateReportActionHandler(){}publicstaticReportActionHandlergetInstance(){returninstance;}/***生成报表*@paramlist*/publicvoidbuildE

6、xcelReport(Listlist){workbook=newHSSFWorkbook();//创建一个Excel文件ReportActionHandler.getInstance().initCellStyle();workbook.createSheet();//创建一个Excel的SheetStringreportTitlt=null;//Excel文档标题ListcolTitle=null;//Excel第一列标题buildExcelReportTempla

7、te(reportTitlt,colTitle);Listdata=list;//Excel封装的数据buildExcelReportData(data);StringfootRowMessage=null;//Excel最后一列的内容buildExcelReportFootRow(footRowMessage);setSheetHeight();StringfileName=null;//网络文件名称sendExcelReport(fileName);}/***构建excel报表模板

8、*@paramworkbook*@paramsheet*@paramreportTitle报表标题*@paramcolTitle列标题*/privatevoidbuildExcelReportTemplate(StringreportTitle,ListcolTitle){try{HSSFSheetsheet=workbook.getSheetAt(0);//创建第一行HSSFRow