ireport导出excel,html.pdf等格式完整实例

本例报表中的数据是List传入的值，不是通过报表执行查询的数据。本例是基于struts使用的。利用ireport工具导出excel

 

一、导入irport相关的jar包导入

common-digester-1[1].7.jar

commons-javaflow-200060411.jar

itext-1.3.jar

iTextAsian.jar

jasperreports-1.2.4.jar

jcommon-1.0.16.jar

jfreechart-1.0.13.jar

poi-2.0-final-20010126.jar

需要注意的是：jar包的版本一定要注意，如果本版不同的话，很容易引起错误的。

 二、在ireport中画出，需要显示的字段样式 （网上有很多这样的例子，这里就不说怎么制作ireport文件了）如下是我制作的文件样式，编译生成.jasper我们需要的这个xx.jasper文件。

三、①当页面点击“导出”时，会执行action中的exportexcel （）方法。（需要注意的是如果页面用的是ajax请求action那么，不一定能够出现下载页面，但是我没有验证，因为以前我做过的是poi导出excel时用ajax请求action时不行，所以最好不要用ajax请求action）

/***导出数据* @param "excel"导出文件文件格式* @param "intentpro2.jasper" ireport编译生成的.jasper文件* @param alllist  需要导出的数据的list值* @param fianceInfo  当导出是默认的文件名称* @return String*/public String exportexcel(){JasperHelper.exportmain("excel", "intentpro2.jasper", alllist, "fianceInfo");return SUCCESS;}

②JasperHelper类

import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import java.lang.reflect.Field;import java.util.Collection;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.servlet.ServletOutputStream;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.log4j.Logger;import org.apache.struts2.ServletActionContext;import org.jfree.util.Log;import com.opensymphony.xwork2.ActionContext;import com.qqw.crm.common.dao.impl.BaseDaoImpl;import net.sf.jasperreports.engine.JRDataSource;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JRExporter;import net.sf.jasperreports.engine.JRExporterParameter;import net.sf.jasperreports.engine.JasperExportManager;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperReport;import net.sf.jasperreports.engine.base.JRBaseReport;import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;import net.sf.jasperreports.engine.export.JRHtmlExporter;import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;import net.sf.jasperreports.engine.export.JRRtfExporter;import net.sf.jasperreports.engine.export.JRXlsExporter;import net.sf.jasperreports.engine.export.JRXlsExporterParameter;import net.sf.jasperreports.engine.util.JRLoader;public class JasperHelper {private static Logger logger = Logger.getLogger(JasperHelper.class);   public static final String PRINT_TYPE = "print";   public static final String PDF_TYPE = "pdf";   public static final String EXCEL_TYPE = "excel";   public static final String HTML_TYPE = "html";   public static final String WORD_TYPE = "word"; public static void prepareReport(JasperReport jasperReport, String type) { logger.debug("The method======= prepareReport() start.......................");    /*     * 如果导出的是excel，则需要去掉周围的margin     */    if ("excel".equals(type))     try {      Field margin = JRBaseReport.class        .getDeclaredField("leftMargin");      margin.setAccessible(true);      margin.setInt(jasperReport, 0);      margin = JRBaseReport.class.getDeclaredField("topMargin");      margin.setAccessible(true);      margin.setInt(jasperReport, 0);      margin = JRBaseReport.class.getDeclaredField("bottomMargin");      margin.setAccessible(true);      margin.setInt(jasperReport, 0);      Field pageHeight = JRBaseReport.class        .getDeclaredField("pageHeight");      pageHeight.setAccessible(true);      pageHeight.setInt(jasperReport, 2147483647);     } catch (Exception exception) {     }   }   /**    * 导出excel    */   public static void exportExcel(JasperPrint jasperPrint,String defaultFilename,     HttpServletRequest request, HttpServletResponse response) throws IOException, JRException {   logger.debug("执行导出excel   The method======= exportExcel() start.......................");     /*      * 设置头信息      */     response.setContentType("application/vnd.ms-excel");     String defaultname=null;     if(defaultFilename.trim()!=null&&defaultFilename!=null){    defaultname=defaultFilename+".xls";     }else{    defaultname="export.xls";     }     String fileName = new String(defaultname.getBytes("gbk"), "utf-8");     response.setHeader("Content-disposition", "attachment; filename="       + fileName);     ServletOutputStream ouputStream = response.getOutputStream();     JRXlsExporter exporter = new JRXlsExporter();     exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);     exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,ouputStream);     exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);     exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);     exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);     exporter.exportReport();     ouputStream.flush();     ouputStream.close();   }   /**    * 导出pdf，注意此处中文问题，     * 这里应该详细说：主要在ireport里变下就行了。看图    * 1）在ireport的classpath中加入iTextAsian.jar    * 2）在ireport画jrxml时，看ireport最左边有个属性栏。    * 下边的设置就在点字段的属性后出现。    * pdf font name ：STSong-Light ，pdf encoding ：UniGB-UCS2-H    */   private static void exportPdf(JasperPrint jasperPrint,String defaultFilename,     HttpServletRequest request, HttpServletResponse response) throws IOException, JRException {     response.setContentType("application/pdf");     String defaultname=null;     if(defaultFilename.trim()!=null&&defaultFilename!=null){    defaultname=defaultFilename+".pdf";     }else{    defaultname="export.pdf";     }     String fileName = new String(defaultname.getBytes("GBK"), "ISO8859_1");     response.setHeader("Content-disposition", "attachment; filename="       + fileName);     ServletOutputStream ouputStream = response.getOutputStream();     JasperExportManager.exportReportToPdfStream(jasperPrint,       ouputStream);     ouputStream.flush();     ouputStream.close();   }   /**    * 导出html    */   private static void exportHtml(JasperPrint jasperPrint,String defaultFilename,     HttpServletRequest request, HttpServletResponse response) throws IOException, JRException {     response.setContentType("text/html");     ServletOutputStream ouputStream = response.getOutputStream();     JRHtmlExporter exporter = new JRHtmlExporter();     exporter.setParameter(       JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN,       Boolean.FALSE);     exporter       .setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);     exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING,       "UTF-8");     exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,       ouputStream);     exporter.exportReport();     ouputStream.flush();     ouputStream.close();   }   /**    * 导出word    */   private static void exportWord(JasperPrint jasperPrint,String defaultFilename,     HttpServletRequest request, HttpServletResponse response)     throws JRException, IOException {    response.setContentType("application/msword;charset=utf-8");    String defaultname=null;     if(defaultFilename.trim()!=null&&defaultFilename!=null){    defaultname=defaultFilename+".doc";     }else{    defaultname="export.doc";     }    String fileName = new String(defaultname.getBytes("GBK"), "utf-8");    response.setHeader("Content-disposition", "attachment; filename="      + fileName);    JRExporter exporter = new JRRtfExporter();    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response      .getOutputStream());    exporter.exportReport();   }   /**    * 按照类型导出不同格式文件    *     * @param datas    *            数据    * @param type    *            文件类型    * @param is    *            jasper文件的来源    * @param request    * @param response    * @param defaultFilename默认的导出文件的名称    */   private static void export(Collection datas, String type,String defaultFilename, InputStream is,     HttpServletRequest request, HttpServletResponse response) {    logger.debug("导出判断     The method======= export() start.......................");    try {     JasperReport jasperReport = (JasperReport) JRLoader.loadObject(is);     prepareReport(jasperReport, type);    JRDataSource ds = new JRBeanCollectionDataSource(datas, false);     Map parameters = new HashMap();   // parameters.put("wheresql", " and status='3'");    /* parameters.put("wheresql", "");       String diver = "oracle.jdbc.driver.OracleDriver";String url = "jdbc:oracle:thin:@192.168.1.156:1521:orcl";String username = "qqwcrm0625";String password = "qqwcrm";ReportDataSource datasource = new ReportDataSource();datasource.setDiver(diver);datasource.setUrl(url);datasource.setUsername(username);datasource.setPassword(password);Connection con=getConnection(datasource);*/     JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, ds);     if (EXCEL_TYPE.equals(type)) {      exportExcel(jasperPrint,defaultFilename, request, response);     } else if (PDF_TYPE.equals(type)) {      exportPdf(jasperPrint,defaultFilename, request, response);     } else if (HTML_TYPE.equals(type)) {      exportHtml(jasperPrint,defaultFilename, request, response);     } else if (WORD_TYPE.equals(type)) {      exportWord(jasperPrint,defaultFilename, request, response);     }    } catch (Exception e) {     e.printStackTrace();    }   }   /**    * 导出入口    *     * @param exportType    *            导出文件的类型    * @param jaspername    *            jasper文件的名字 如： xx.jasper    * @param lists    *           导出的数据    * @param request    * @param response    * @param defaultFilename默认的导出文件的名称    */   public static void exportmain(String exportType,String jaspername,List lists,String defaultFilename){   logger.debug("进入导出    The method======= exportmain() start.......................");   ActionContext ct = ActionContext.getContext();   HttpServletRequest request = (HttpServletRequest) ct.get(ServletActionContext.HTTP_REQUEST);   HttpServletResponse response = ServletActionContext.getResponse();String filenurl=request.getRealPath("/ireport/"+jaspername);//jasper文件放在WebRoot/ireport/xx.jasper   File file = new File(filenurl);        InputStream is = null;        try {is = new FileInputStream(file);} catch (FileNotFoundException e) {e.printStackTrace();}export(lists,exportType,defaultFilename,is,request,response);   }} 

③ struts配置文件中的配置，没有什么特别的

<action name="exportexcel" class="intentProVoList"  method="exportexcel"><result name="success"></result></action> 

 四、特别注意：在ireport中的fields中，各个字段的名称一定要与list中的各个对象的name一样。是区分大小写的。所以大小写也要一致