ireport new java.lang.boolean,润乾集算报表应用开发之Excel及PDF导出

报表应用中有时报表只需生成指定文件，而无需在页面展现，生成的文件常见于Excel、PDF等。由于报表不展现，也就无需使用报表提供的tag，可以直接通过程序导出。集算报表提供了丰富的API，允许开发人员编写代码实现自己的业务逻辑。这里通过在servlet中导出Excel为例来看一下报表不展现而直接导出的实现方式。

定义导出Excel的servlet(ExportToExcel)，主要代码如下：

1、接收参数

String report = request.getParameter("rpx");

String year = request.getParameter("year");

2、读入报表

String reportFile =

request.getSession().getServletContext().getRealPath("/reportFiles/"+report);

3、读入并计算报表

Context cxt = new Context();

ReportDefine rd =

(ReportDefine)ReportUtils.read(reportFile);

cxt.setParamValue("year", year);

Engine engine = new Engine(rd, cxt);

IReport iReport = engine.calc();

4、导出Excel

ReportUtils.exportToExcel("D:/result.xls", iReport,

true);

导出的Excel效果如下：

集算报表提供了多个导出Excel的方法，除了可以导出xls格式，也可以导出xlsx格式文件，开发人员可以根据需求选择导出Excel的方法：

ReportUtils.exportToExcel(java.io.OutputStream

os, IReport report, boolean pageBroken);

ReportUtils.exportToExcel(java.io.OutputStream

os, IReport report, boolean pageBroken, int dispRatio);

ReportUtils.exportToExcel(java.lang.String

fileName, IReport report, boolean pageBroken);

ReportUtils.exportToExcel(java.lang.String

fileName, IReport report, boolean pageBroken, int

dispRatio);

ReportUtils.exportToExcel

2007(java.lang.String fileName,IReport report,boolean

pageBroken)

ReportUtils.exportToExcel

2007(java.io.OutputStream os,IReport report,boolean

pageBroken)

导出PDF与导出Excel类似，调用相应导出PDF的方法即可，集算报表提供导出PDF的方法包括：

ReportUtils.exportToPDF(java.io.OutputStream

os, IReport report);

ReportUtils.exportToPDF(java.io.OutputStream

os, IReport report, boolean pageBroken, boolean

graphicOut)

ReportUtils.exportToPDF(java.lang.String

fileName, IReport report);

ReportUtils.exportToPDF(java.lang.String

fileName, IReport report, boolean pageBroken, boolean

graphicOut)

【附】导出Excel完整代码

package

com.runqian.servlet;

import

java.io.File;

import

java.io.IOException;

import

java.io.PrintWriter;

import

javax.servlet.ServletException;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

com.raqsoft.report.model.ReportDefine;

import

com.raqsoft.report.usermodel.Context;

import

com.raqsoft.report.usermodel.Engine;

import

com.raqsoft.report.usermodel.IReport;

import

com.raqsoft.report.usermodel.ParamMetaData;

import

com.raqsoft.report.util.ReportUtils;

public

class ExportToExcel extends HttpServlet

{

public ExportToExcel() {

super();

}

public void destroy() {

super.destroy(); // Just puts "destroy" string in

log

// Put your code here

}

public void doGet(HttpServletRequest request,

HttpServletResponse response)

throws ServletException, IOException {

String report = request.getParameter("rpx");

String year = request.getParameter("year");

//保证报表名称的完整性

int iTmp = 0;

if( (iTmp = report.lastIndexOf(".rpx")) <= 0

){

report = report + ".rpx";

iTmp = 0;

}

String reportFile =

request.getSession().getServletContext().getRealPath("/reportFiles/"+report);

Context cxt = new Context();

try {

ReportDefine rd =

(ReportDefine)ReportUtils.read(reportFile);

cxt.setParamValue("year", year);

Engine engine = new Engine(rd,

cxt); //构造报表引擎

IReport iReport =

engine.calc(); //运算报表

ReportUtils.exportToExcel("D:\\result.xls", iReport,

true);

} catch (Throwable e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public void doPost(HttpServletRequest request,

HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println("");

out.println("");

out.println("

");

out.println("

");

out.print(" This is ");

out.print(this.getClass());

out.println(", using the POST method");

out.println("

");

out.println("

");

out.flush();

out.close();

}

public void init() throws ServletException

{

// Put your code here

}

}