Exel with multiple sheets

lukasw44

Hello
1)how can i easy create reports with multiple exel worksseet ??
i am using birt 3.7.2 and eclipse plugin ..

and 2 .
2)how can i easy create reports with multiple pages.
next page == next report (in print view)??

wher can i found some tutorial how to do that ?

lukasw44

I think i need add new emmiter<br />
Tribix XML<br />
so i am add new file into my lib and classpath :<br />
org.uguess.birt.report.engine.common_2.5.2.201107181644.jar<br />
org.uguess.birt.report.engine.emitter.xls_2.5.2.201107181644.jar<br />
<br />
but i have got error : <br />
<pre class='_prettyXprint _lang-auto _linenums:0'>lis 09, 2012 11:39:48 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager createObject
WARNING: Can not instantiate class org.uguess.birt.report.engine.emitter.xls.XlsEmitter with property class.
lis 09, 2012 11:39:48 AM org.eclipse.birt.report.engine.api.impl.EngineTask createContentEmitter
SEVERE: Report engine can not create xls emitter.
Exception in thread "main" org.eclipse.birt.report.engine.api.EngineException: Report engine fails to initialize xls emitter, please make sure required libraries for this emitter are installed.
at org.eclipse.birt.report.engine.api.impl.EngineTask.createContentEmitter(EngineTask.java:1593)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:105)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at pl.asseco.acm.birt.BirtStaticTest.main(BirtStaticTest.java:65)</pre>
<br />
this is my code : <br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
public class BirtStaticTest {

public static void main(String... args) throws BirtException, FileNotFoundException {
EngineConfig engineConfig = new EngineConfig();

engineConfig.setLogConfig(null, Level.WARNING);

IPlatformContext context = new PlatformFileContext();
engineConfig.setPlatformContext(context);

Platform.startup(engineConfig);
IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);

IReportEngine reportEngine = factory.createReportEngine(engineConfig);




String fileName = "web/report.rptdesign";

IReportRunnable runnable = reportEngine.openReportDesign(fileName);
IRunAndRenderTask runAndRenderTask = reportEngine.createRunAndRenderTask(runnable);


EXCELRenderOption renderOption = new EXCELRenderOption();
renderOption.setOutputFormat("xls");
renderOption.setEnableMultipleSheet(true);
renderOption.setOutputStream(new FileOutputStream("c:\\out.xls"));



renderOption.setOption(IRenderOption.EMITTER_ID, "org.uguess.birt.report.engine.emitter.xls");

HashMap<String, Object> contextMap = new HashMap<String, Object>();
Map<String, String> paramValues = new HashMap<String, String>();


//runAndRenderTask.getEngine().getConfig().getEmitterConfigs().
//runAndRenderTask.setParameterValues(paramValues);
runAndRenderTask.setRenderOption(renderOption);
runAndRenderTask.run();

reportEngine.shutdown();

System.out.println("end");
}


}
</pre>