ireport生成excel

<%@ page language="java" contentType="application/vnd.ms-excel; charset=gbk"
pageEncoding="gbk"%>







<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%


File reportFile = new File(application.getRealPath("/ireport/myreport.jasper"));
Connection conn =null ;
String url="jdbc:oracle:thin:@192.168.1.251:1521:ad";
String driver="oracle.jdbc.driver.OracleDriver";
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,"sdf","asda");
Map parameters = new HashMap();
//String str=JasperRunManager.runReportToHtmlFile(reportFile.getPath(),parameters,conn);
//String str=JasperRunManager.runReportToHtmlFile(reportFile.getPath(),parameters,new JREmptyDataSource());
//System.out.println(str);

//生成EXCEL
JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile.getPath(),parameters,conn);

JRXlsExporter exporter = new JRXlsExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream());
exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); // 删除记录最下面的空行
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);// 删除多余的ColumnHeader
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);// 显示边框
exporter.exportReport();
response.setContentType("application/vnd.ms-excel");
conn.close();

}catch(Exception e){
e.printStackTrace();
}
%>