Home » Archived » BIRT » How to generate XLS or DOC by using REAPI
How to generate XLS or DOC by using REAPI [message #250369] |
Mon, 30 July 2007 09:16  |
Eclipse User |
|
|
|
Hi,
does anyone know how to generate XLS or DOC format per Birt 2.2 Report
Engine API ?
i can generate PDF and HTML by using HTML- or PDFRenderOption
programtically, but until now still don not find any example about how to
use Birt 2.2 REAPI to generate XLS or DOC programmatically. Some prevoius
discussions about it do not also give any ideas.
thanks in advance
|
|
| | | |
Re: How to generate XLS or DOC by using REAPI [message #250840 is a reply to message #250751] |
Wed, 01 August 2007 17:52   |
Eclipse User |
|
|
|
Originally posted by: xxxx.xxx.com
Jason, I could be able to generate a report output in XLS but I am
getting annoying log messages as follows in my dos window where I run
the Java class:
add data col = 0
Get Data = [0,0]
Get Data = [0,0]
add data col = 1
Get Data = [1,0]
Get Data = [1,0]
add data col = 2
Get Data = [2,0]
Get Data = [2,0]
Get Data = [0,0]
Get Data = [1,0]
Get Data = [2,0]
Get Data = [0,0]
Is there any way I can avoid this?
Thanks
Jason Weathersby wrote:
> Can you post the entire stack trace.
>
> Here is the complete sample I used:
>
> Jason
>
> import java.util.HashMap;
> import java.util.logging.Level;
>
> import org.eclipse.birt.core.framework.Platform;
> import org.eclipse.birt.report.engine.api.EngineConfig;
> import org.eclipse.birt.report.engine.api.EngineConstants;
> import org.eclipse.birt.report.engine.api.EngineException;
> import org.eclipse.birt.report.engine.api.HTMLActionHandler;
> import org.eclipse.birt.report.engine.api.HTMLRenderOption;
> import org.eclipse.birt.report.engine.api.PDFRenderOption;
> import org.eclipse.birt.report.engine.api.HTMLServerImageHandler;
> import org.eclipse.birt.report.engine.api.IReportEngine;
> import org.eclipse.birt.report.engine.api.IReportEngineFactory;
> import org.eclipse.birt.report.engine.api.IReportRunnable;
> import org.eclipse.birt.report.engine.api.IReportDocument;
>
> import org.eclipse.birt.report.engine.api.IRenderTask;
> import org.eclipse.birt.report.engine.api.IRenderOption;
> import org.eclipse.birt.report.engine.api.RenderOption;
> import org.eclipse.birt.report.engine.api.IHTMLRenderOption;
> import org.eclipse.birt.report.engine.api.IPDFRenderOption;
>
>
>
>
>
> public class RenderTaskXLS {
>
> public void runReport() throws EngineException
> {
>
> IReportEngine engine=null;
> EngineConfig config = null;
>
> try{
>
> config = new EngineConfig( );
>
> config.setBIRTHome("C:/birt/birt-runtime-2_2_0/birt-runtime-2_2_0/ReportEngine ");
>
> config.setLogConfig(null, Level.FINE);
> Platform.startup( config );
> IReportEngineFactory factory = (IReportEngineFactory)
> Platform.createFactoryObject(
> IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
> engine = factory.createReportEngine( config );
> }catch( Exception ex){
> ex.printStackTrace();
> }
>
> IReportDocument document = null;
> //Open the report design
> document =
> engine.openReportDocument("output/resample/customers.rptdocument ");
>
> IRenderOption options = new RenderOption();
>
> options.setOutputFormat("xls");
> options.setOutputFileName("output/resample/customers.xls");
>
>
>
> IRenderTask task = engine.createRenderTask(document);
> task.setRenderOption(options);
>
> task.render();
>
>
>
>
>
> task.close();
> engine.destroy();
> Platform.shutdown();
> System.out.println("Finished");
> }
>
>
> /**
> * @param args
> */
> public static void main(String[] args) {
> try
> {
>
> RenderTaskXLS ex = new RenderTaskXLS( );
> ex.runReport();
>
> }
> catch ( Exception e )
> {
> e.printStackTrace();
> }
> }
>
>
> }
>
> Said wrote:
>> Hi,
>> I tried the this example but I get the following error:
>>
>> org.eclipse.birt.report.engine.api.EngineException
>> at
>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:395)
>>
>> at
>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:342)
>>
>> at
>> org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDocument(ReportEngine.java:423)
>>
>>
|
|
|
Re: How to generate XLS or DOC by using REAPI [message #250871 is a reply to message #250840] |
Wed, 01 August 2007 23:32   |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Can you set the log level to OFF?
Jason
Kris wrote:
> Jason, I could be able to generate a report output in XLS but I am
> getting annoying log messages as follows in my dos window where I run
> the Java class:
>
> add data col = 0
> Get Data = [0,0]
> Get Data = [0,0]
> add data col = 1
> Get Data = [1,0]
> Get Data = [1,0]
> add data col = 2
> Get Data = [2,0]
> Get Data = [2,0]
> Get Data = [0,0]
> Get Data = [1,0]
> Get Data = [2,0]
> Get Data = [0,0]
>
> Is there any way I can avoid this?
>
> Thanks
>
>
> Jason Weathersby wrote:
>> Can you post the entire stack trace.
>>
>> Here is the complete sample I used:
>>
>> Jason
>>
>> import java.util.HashMap;
>> import java.util.logging.Level;
>>
>> import org.eclipse.birt.core.framework.Platform;
>> import org.eclipse.birt.report.engine.api.EngineConfig;
>> import org.eclipse.birt.report.engine.api.EngineConstants;
>> import org.eclipse.birt.report.engine.api.EngineException;
>> import org.eclipse.birt.report.engine.api.HTMLActionHandler;
>> import org.eclipse.birt.report.engine.api.HTMLRenderOption;
>> import org.eclipse.birt.report.engine.api.PDFRenderOption;
>> import org.eclipse.birt.report.engine.api.HTMLServerImageHandler;
>> import org.eclipse.birt.report.engine.api.IReportEngine;
>> import org.eclipse.birt.report.engine.api.IReportEngineFactory;
>> import org.eclipse.birt.report.engine.api.IReportRunnable;
>> import org.eclipse.birt.report.engine.api.IReportDocument;
>>
>> import org.eclipse.birt.report.engine.api.IRenderTask;
>> import org.eclipse.birt.report.engine.api.IRenderOption;
>> import org.eclipse.birt.report.engine.api.RenderOption;
>> import org.eclipse.birt.report.engine.api.IHTMLRenderOption;
>> import org.eclipse.birt.report.engine.api.IPDFRenderOption;
>>
>>
>>
>>
>>
>> public class RenderTaskXLS {
>>
>> public void runReport() throws EngineException
>> {
>>
>> IReportEngine engine=null;
>> EngineConfig config = null;
>>
>> try{
>> config = new EngineConfig( );
>> config.setBIRTHome("C:/birt/birt-runtime-2_2_0/birt-runtime-2_2_0/ReportEngine ");
>>
>> config.setLogConfig(null, Level.FINE);
>> Platform.startup( config );
>> IReportEngineFactory factory = (IReportEngineFactory)
>> Platform.createFactoryObject(
>> IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
>> engine = factory.createReportEngine( config );
>> }catch( Exception ex){
>> ex.printStackTrace();
>> }
>>
>> IReportDocument document = null;
>> //Open the report design
>> document =
>> engine.openReportDocument("output/resample/customers.rptdocument ");
>>
>> IRenderOption options = new RenderOption();
>> options.setOutputFormat("xls");
>> options.setOutputFileName("output/resample/customers.xls");
>>
>> IRenderTask task = engine.createRenderTask(document);
>> task.setRenderOption(options);
>> task.render();
>>
>>
>>
>> task.close();
>> engine.destroy();
>> Platform.shutdown();
>> System.out.println("Finished");
>> }
>>
>> /**
>> * @param args
>> */
>> public static void main(String[] args) {
>> try
>> {
>>
>> RenderTaskXLS ex = new RenderTaskXLS( );
>> ex.runReport();
>>
>> }
>> catch ( Exception e )
>> {
>> e.printStackTrace();
>> }
>> }
>>
>> }
>>
>> Said wrote:
>>> Hi,
>>> I tried the this example but I get the following error:
>>>
>>> org.eclipse.birt.report.engine.api.EngineException
>>> at
>>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:395)
>>>
>>> at
>>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:342)
>>>
>>> at
>>> org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDocument(ReportEngine.java:423)
>>>
>>>
|
|
| |
Re: How to generate XLS or DOC by using REAPI [message #252545 is a reply to message #250840] |
Wed, 15 August 2007 11:26   |
Eclipse User |
|
|
|
Originally posted by: xxxx.xxx.com
Jason, I couldnt stop (with log level OFF) displaying these messaged
from printing. One thing I am noticing about these messages that they
dont look like (message format) they are from the logger but from a
debug statement like System.out.println().
Is there any possibility that any developer could ve left that debug
statement in there and forgot to take it out?
Thanks
Kris wrote:
> Jason, I could be able to generate a report output in XLS but I am
> getting annoying log messages as follows in my dos window where I run
> the Java class:
>
> add data col = 0
> Get Data = [0,0]
> Get Data = [0,0]
> add data col = 1
> Get Data = [1,0]
> Get Data = [1,0]
> add data col = 2
> Get Data = [2,0]
> Get Data = [2,0]
> Get Data = [0,0]
> Get Data = [1,0]
> Get Data = [2,0]
> Get Data = [0,0]
>
> Is there any way I can avoid this?
>
> Thanks
>
>
> Jason Weathersby wrote:
>> Can you post the entire stack trace.
>>
>> Here is the complete sample I used:
>>
>> Jason
>>
>> import java.util.HashMap;
>> import java.util.logging.Level;
>>
>> import org.eclipse.birt.core.framework.Platform;
>> import org.eclipse.birt.report.engine.api.EngineConfig;
>> import org.eclipse.birt.report.engine.api.EngineConstants;
>> import org.eclipse.birt.report.engine.api.EngineException;
>> import org.eclipse.birt.report.engine.api.HTMLActionHandler;
>> import org.eclipse.birt.report.engine.api.HTMLRenderOption;
>> import org.eclipse.birt.report.engine.api.PDFRenderOption;
>> import org.eclipse.birt.report.engine.api.HTMLServerImageHandler;
>> import org.eclipse.birt.report.engine.api.IReportEngine;
>> import org.eclipse.birt.report.engine.api.IReportEngineFactory;
>> import org.eclipse.birt.report.engine.api.IReportRunnable;
>> import org.eclipse.birt.report.engine.api.IReportDocument;
>>
>> import org.eclipse.birt.report.engine.api.IRenderTask;
>> import org.eclipse.birt.report.engine.api.IRenderOption;
>> import org.eclipse.birt.report.engine.api.RenderOption;
>> import org.eclipse.birt.report.engine.api.IHTMLRenderOption;
>> import org.eclipse.birt.report.engine.api.IPDFRenderOption;
>>
>>
>>
>>
>>
>> public class RenderTaskXLS {
>>
>> public void runReport() throws EngineException
>> {
>>
>> IReportEngine engine=null;
>> EngineConfig config = null;
>>
>> try{
>> config = new EngineConfig( );
>> config.setBIRTHome("C:/birt/birt-runtime-2_2_0/birt-runtime-2_2_0/ReportEngine ");
>>
>> config.setLogConfig(null, Level.FINE);
>> Platform.startup( config );
>> IReportEngineFactory factory = (IReportEngineFactory)
>> Platform.createFactoryObject(
>> IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
>> engine = factory.createReportEngine( config );
>> }catch( Exception ex){
>> ex.printStackTrace();
>> }
>>
>> IReportDocument document = null;
>> //Open the report design
>> document =
>> engine.openReportDocument("output/resample/customers.rptdocument ");
>>
>> IRenderOption options = new RenderOption();
>> options.setOutputFormat("xls");
>> options.setOutputFileName("output/resample/customers.xls");
>>
>> IRenderTask task = engine.createRenderTask(document);
>> task.setRenderOption(options);
>> task.render();
>>
>>
>>
>> task.close();
>> engine.destroy();
>> Platform.shutdown();
>> System.out.println("Finished");
>> }
>>
>> /**
>> * @param args
>> */
>> public static void main(String[] args) {
>> try
>> {
>>
>> RenderTaskXLS ex = new RenderTaskXLS( );
>> ex.runReport();
>>
>> }
>> catch ( Exception e )
>> {
>> e.printStackTrace();
>> }
>> }
>>
>> }
>>
>> Said wrote:
>>> Hi,
>>> I tried the this example but I get the following error:
>>>
>>> org.eclipse.birt.report.engine.api.EngineException
>>> at
>>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:395)
>>>
>>> at
>>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:342)
>>>
>>> at
>>> org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDocument(ReportEngine.java:423)
>>>
>>>
|
|
|
Re: How to generate XLS or DOC by using REAPI [message #252574 is a reply to message #252545] |
Wed, 15 August 2007 14:45  |
Eclipse User |
|
|
|
Please have a look at bug
https://bugs.eclipse.org/bugs/show_bug.cgi?id=198843
It is fixed in 2.2.1.
Spunk
"Kris" <xxxx@xxx.com> schrieb im Newsbeitrag
news:f9v5vh$rt2$1@build.eclipse.org...
> Jason, I couldnt stop (with log level OFF) displaying these messaged from
> printing. One thing I am noticing about these messages that they dont look
> like (message format) they are from the logger but from a debug statement
> like System.out.println().
>
> Is there any possibility that any developer could ve left that debug
> statement in there and forgot to take it out?
>
> Thanks
>
> Kris wrote:
>> Jason, I could be able to generate a report output in XLS but I am
>> getting annoying log messages as follows in my dos window where I run the
>> Java class:
>>
>> add data col = 0
>> Get Data = [0,0]
>> Get Data = [0,0]
>> add data col = 1
>> Get Data = [1,0]
>> Get Data = [1,0]
>> add data col = 2
>> Get Data = [2,0]
>> Get Data = [2,0]
>> Get Data = [0,0]
>> Get Data = [1,0]
>> Get Data = [2,0]
>> Get Data = [0,0]
>>
>> Is there any way I can avoid this?
>>
>> Thanks
>>
>>
>> Jason Weathersby wrote:
>>> Can you post the entire stack trace.
>>>
>>> Here is the complete sample I used:
>>>
>>> Jason
>>>
>>> import java.util.HashMap;
>>> import java.util.logging.Level;
>>>
>>> import org.eclipse.birt.core.framework.Platform;
>>> import org.eclipse.birt.report.engine.api.EngineConfig;
>>> import org.eclipse.birt.report.engine.api.EngineConstants;
>>> import org.eclipse.birt.report.engine.api.EngineException;
>>> import org.eclipse.birt.report.engine.api.HTMLActionHandler;
>>> import org.eclipse.birt.report.engine.api.HTMLRenderOption;
>>> import org.eclipse.birt.report.engine.api.PDFRenderOption;
>>> import org.eclipse.birt.report.engine.api.HTMLServerImageHandler;
>>> import org.eclipse.birt.report.engine.api.IReportEngine;
>>> import org.eclipse.birt.report.engine.api.IReportEngineFactory;
>>> import org.eclipse.birt.report.engine.api.IReportRunnable;
>>> import org.eclipse.birt.report.engine.api.IReportDocument;
>>>
>>> import org.eclipse.birt.report.engine.api.IRenderTask;
>>> import org.eclipse.birt.report.engine.api.IRenderOption;
>>> import org.eclipse.birt.report.engine.api.RenderOption;
>>> import org.eclipse.birt.report.engine.api.IHTMLRenderOption;
>>> import org.eclipse.birt.report.engine.api.IPDFRenderOption;
>>>
>>>
>>>
>>>
>>>
>>> public class RenderTaskXLS {
>>>
>>> public void runReport() throws EngineException
>>> {
>>>
>>> IReportEngine engine=null;
>>> EngineConfig config = null;
>>>
>>> try{
>>> config = new EngineConfig( );
>>> config.setBIRTHome("C:/birt/birt-runtime-2_2_0/birt-runtime-2_2_0/ReportEngine ");
>>> config.setLogConfig(null, Level.FINE);
>>> Platform.startup( config );
>>> IReportEngineFactory factory = (IReportEngineFactory)
>>> Platform.createFactoryObject(
>>> IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
>>> engine = factory.createReportEngine( config );
>>> }catch( Exception ex){
>>> ex.printStackTrace();
>>> }
>>>
>>> IReportDocument document = null;
>>> //Open the report design
>>> document =
>>> engine.openReportDocument("output/resample/customers.rptdocument ");
>>>
>>> IRenderOption options = new RenderOption();
>>> options.setOutputFormat("xls");
>>> options.setOutputFileName("output/resample/customers.xls");
>>> IRenderTask task = engine.createRenderTask(document);
>>> task.setRenderOption(options);
>>> task.render();
>>>
>>>
>>> task.close();
>>> engine.destroy();
>>> Platform.shutdown();
>>> System.out.println("Finished");
>>> }
>>> /**
>>> * @param args
>>> */
>>> public static void main(String[] args) {
>>> try
>>> {
>>>
>>> RenderTaskXLS ex = new RenderTaskXLS( );
>>> ex.runReport();
>>>
>>> }
>>> catch ( Exception e )
>>> {
>>> e.printStackTrace();
>>> }
>>> }
>>>
>>> }
>>>
>>> Said wrote:
>>>> Hi,
>>>> I tried the this example but I get the following error:
>>>>
>>>> org.eclipse.birt.report.engine.api.EngineException
>>>> at
>>>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:395)
>>>> at
>>>> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDocument(ReportEngineHelper.java:342)
>>>> at
>>>> org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDocument(ReportEngine.java:423)
>>>>
|
|
|
Goto Forum:
Current Time: Wed May 28 17:56:27 EDT 2025
Powered by FUDForum. Page generated in 0.02852 seconds
|