帆软多个报表合并成一个excel 下载

官方的收费，采用二次开发。

package com.multek.finereport.io;

import com.fr.base.Parameter;
import com.fr.base.operator.common.CommonOperator;
import com.fr.chart.activator.ChartBaseActivator;
import com.fr.cluster.engine.activator.standalone.StandaloneModeActivator;
import com.fr.config.activator.BaseDBActivator;
import com.fr.config.activator.ConfigurationActivator;
import com.fr.env.operator.CommonOperatorImpl;
import com.fr.general.I18nResource;
import com.fr.health.activator.ModuleHealActivator;
import com.fr.io.ResourceRepositoryActivator;
import com.fr.io.TemplateWorkBookIO;
import com.fr.io.exporter.PageExcelExporter;
import com.fr.main.TemplateWorkBook;
import com.fr.main.impl.WorkBook;
import com.fr.main.workbook.PageWorkBook;
import com.fr.module.Module;
import com.fr.module.tool.ActivatorToolBox;
import com.fr.report.ReportActivator;
import com.fr.report.RestrictionActivator;
import com.fr.report.core.ReportUtils;
import com.fr.report.module.ReportBaseActivator;
import com.fr.report.report.PageReport;
import com.fr.report.write.WriteActivator;
import com.fr.scheduler.SchedulerActivator;
import com.fr.stable.PageActor;
import com.fr.store.StateServiceActivator;
import com.fr.workspace.simple.SimpleWork;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.HashMap;
import java.util.Map;

public class ExportReports {
    public static void main(String[] args) {
        // 首先需要定义执行所在的环境，这样才能正确读取数据库信息
        // 定义报表运行环境,用于执行报表
        Module module = ActivatorToolBox.simpleLink(new BaseDBActivator(),
                new ConfigurationActivator(),
                new ResourceRepositoryActivator(),
                new StandaloneModeActivator(),
                new ModuleHealActivator(),
                new StateServiceActivator(),
                new ChartBaseActivator(),
                new SchedulerActivator(),
                new ReportBaseActivator(),
                new RestrictionActivator(),
                new ReportActivator(),
                new WriteActivator());
        SimpleWork.supply(CommonOperator.class, new CommonOperatorImpl());
        String envpath = "D:\\FineReport_10.0\\webapps\\webroot\\WEB-INF";//工程路径
        SimpleWork.checkIn(envpath);
        I18nResource.getInstance();
        module.start();


        // 进行程序的一些必要初始化
        try {
            WorkBook workbook = (WorkBook) TemplateWorkBookIO.readTemplateWorkBook("MFG/PPC/ShopFloor_WIPSum.cpt");
            WorkBook workbook2 = (WorkBook) TemplateWorkBookIO.readTemplateWorkBook("MFG/PPC/ShopFloor_WIP.cpt");
            // 设置传入的参数
            Map parameterMap = new HashMap();
            //   parameterMap.put("地区","华东");
            // 定义输出流
            FileOutputStream outputStream;
            String outputUrl="d:\\test\\";

            PageWorkBook rworkbook = (PageWorkBook)workbook.execute(parameterMap,new PageActor());
            rworkbook.setReportName(0, "华东");

            PageWorkBook rworkbook2 = (PageWorkBook)workbook2.execute(parameterMap,new PageActor());
            PageReport rreport2 = rworkbook2.getPageReport(0);
            rworkbook.addReport("华北", rreport2);
            // 将结果工作薄导出为Excel文件
            outputStream = new FileOutputStream(new File("d:\\test\\ExcelExport1.xls"));
            PageExcelExporter excelExport = new PageExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook));
            excelExport.export(outputStream, rworkbook);

            /**将结果工作薄导出为2007Excel文件*/
             /*outputStream = new FileOutputStream(new java.io.File(outputUrl+"ExcelExport2007.xlsx"));
            StreamExcel2007Exporter ExcelExport1 = new StreamExcel2007Exporter();
            ExcelExport1.export(outputStream, workbook.execute(parameterMap, new WriteActor()));
            */
            outputStream.close();
            module.stop();

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