pageEncoding=”gbk”%>
<%@page
import=”com.runqian.report4.usermodel.*,com.runqian.report4.util.*,com.runqian.report4.model.ReportDefine”%>
< %@ page import=”java.io.*,com.runqian.report4.usermodel.DataSetConfig,java.util.*,com.runqian.report4.view.excel.ExcelReport”%>
< %
List<String> list = new ArrayList<String>();
list.add(“F:/1.raq”);
list.add(“F:/2.raq”);
list.add(“F:/3.raq”);
System.out.println(“共有”+list.size()+”个raq文件”);
OutputStream os = new FileOutputStream(“F:/Reports.xls”);
ExcelReport er = new ExcelReport();
for(int i = 0; i<list.size(); i++){
ReportDefine rd = (ReportDefine)ReportUtils.read(list.get(i));
Context ctx = new Context();
Engine engine = new Engine(rd,ctx);
IReport ireport = engine.calc();
System.out.println(“i=============”+i);
er.export(“sheet_”+String.valueOf(i),ireport);
}
er.saveTo(“F:/Reports.xls”);
//System.out.println(“已经导出了一个sheet_”+i);
os.close();
%>
第三步:运行jsp,导出报表文件。