ireport group_ireport table_java ireport案例(4)

(4) 在ireport里给fields加上border,那输出的excel就会有很黑的边框，跟excel默认的灰度边框就会很不协调。但是如果不加border,在输出的excel里就不会显示每个表格的边框。

解决方法是:

第一步 在选中字段->右键->properties->Common->Transparent 打上勾。

第二步 在输出的jsp页面加上参数

exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);

4.2.3 jsp输出EXCEL的例子:xls.jsp

<%@ page import="java.sql.*" %>

<%@ page import="java.util.*" %>

<%@ page import="java.io.*" %>

<%@ page import="net.sf.jasperreports.engine.JasperFillManager" %>

<%@ page import="net.sf.jasperreports.engine.JasperPrint"%>

<%@ page import="net.sf.jasperreports.engine.JRException"%>

<%@ page import="net.sf.jasperreports.engine.JRExporterParameter"%>//excel

<%@ page import="net.sf.jasperreports.engine.export.JRXlsExporterParameter"%>//excel

<%@ page import="net.sf.jasperreports.engine.export.JRXlsExporter"%>//excel

<%

String rowid = "1";

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@*:*", "*","*");

//装载jasper文件application

File exe_rpt = new File(application.getRealPath("/ireports/report3.jasper"));

//rowid就是iReport的变量$P{rowid}的名称

Map parameters = new HashMap();

parameters.put("getId", "50");

try{

// fill

JasperPrint jasperPrint = JasperFillManager.fillReport(exe_rpt.getPath(),parameters,conn);

// excel输出

ByteArrayOutputStream oStream = new ByteArrayOutputStream();

JRXlsExporter exporter = new JRXlsExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-35158-4.html