Eclipse Community Forums: BIRT » Is EXCEL output compatible with open office?

Help

Home

Home » Archived » BIRT » Is EXCEL output compatible with open office?

Show: Today's Messages :: Show Polls :: Message Navigator

Is EXCEL output compatible with open office? [message #501669]

Thu, 03 December 2009 11:27

Mr. Munter

Messages: 10
Registered: November 2009

Junior Member

HI,

I've been trying to output a report to xls and open it in open office but all I get is the XLS XML pasted into the spreadsheet. Is the Excel output compatible with openoffice as I don't have MS Office? I also tried it on google docs but i get an error when it is importing.

I even created a simple test report with a simple table of a few cells and setting the output to different office versions but no luck.

This is the code i used to create the xls, maybe i'm missing some parameters.

Thanks in advance.

try {

config.getAppContext().put("PARENT_CLASSLOADER", report);
IReportRunnable design = reportEngine.openReportDesign(" C:/dev/triental/rebel/rebelYell/web/src/main/java/com/trient al/gps/reports/test.rptdesign ");

IRunAndRenderTask task = reportEngine.createRunAndRenderTask(design);
task.getAppContext().put("myObject", report);

//RenderOption options = null;

EXCELRenderOption options = new EXCELRenderOption();
options.setOfficeVersion("office2003");
options.setOutputFileName("c:/temp/rebelTest888.xls");
//options.setOutputStream(os);
options.setOutputFormat("xls");

task.setRenderOption(options);
task.run();
task.close();

Report message to a moderator

Re: Is EXCEL output compatible with open office? [message #501762 is a reply to message #501669]

Thu, 03 December 2009 17:21

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Take a look at this bugzilla entry:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=278313

Mr. Munter wrote:
> HI,
>
> I've been trying to output a report to xls and open it in open office
> but all I get is the XLS XML pasted into the spreadsheet. Is the Excel
> output compatible with openoffice as I don't have MS Office? I also
> tried it on google docs but i get an error when it is importing.
>
> I even created a simple test report with a simple table of a few cells
> and setting the output to different office versions but no luck.
>
> This is the code i used to create the xls, maybe i'm missing some
> parameters.
>
> Thanks in advance.
>
> try {
>
> config.getAppContext().put("PARENT_CLASSLOADER", report);
> IReportRunnable design = reportEngine.openReportDesign("
> C:/dev/triental/rebel/rebelYell/web/src/main/java/com/trient
> al/gps/reports/test.rptdesign ");
>
> IRunAndRenderTask task =
> reportEngine.createRunAndRenderTask(design);
> task.getAppContext().put("myObject", report);
>
> //RenderOption options = null;
>
> EXCELRenderOption options = new EXCELRenderOption();
> options.setOfficeVersion("office2003");
> options.setOutputFileName("c:/temp/rebelTest888.xls");
> //options.setOutputStream(os);
> options.setOutputFormat("xls");
>
> task.setRenderOption(options);
> task.run();
> task.close();

Report message to a moderator

Previous Topic:	how to test for a file/directory in javascript using BIRT
Next Topic:	ScalarParameterDefn.getUserPropertyValue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:53:01 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter