Disabling MultiSheet in Excel Report

[GoogleCodeExporter]

First of all, Thank you very much for the Excel Emitter for Birt Report. We are 
using it to generate Binary version. I was not able to switch off Multi sheet 
generation. We are using repot Engine (BIRT 3.7).

EXCELRenderOption emitter = new EXCELRenderOption();       
emitter.setOutputFormat();                                          
emitter.setOption("org.eclipse.birt.report.engine.emitter.nativexls");
emitter.setEnableMultipleSheet(false);

I did try to debug your source code and I came across             public void 
startPage( IPageContent pageContent ) throws BirtException Line 137 of 
ExcelLayoutEngine.java being called twice and each time inside  the if statement

if ( page == null || context.isEnableMultipleSheet( ) ){
.....
......
}

page variable is null

I Suspect page variable need to be set before the if statement

i.e 
page = context.getPage();
if ( page == null || context.isEnableMultipleSheet( ) ){
 .....
 .....
}

Could you please advice me on the above problem.
Your help is highly Appreciated.

Original issue reported on code.google.com by konerusuresh on 24 Oct 2011 at 1:43

[GoogleCodeExporter]

What steps will reproduce the problem?
1) Remove the following jars from the eclipse\plugin folder
• org.eclipse.birt.report.engine.emitter.excel.config_2.6.2.r262_v20110127.jar
• 
org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.2.r262_v20110215.jar
2) Copy org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114 
into eclipse\plugin folder 

What is the expected output? What do you see instead?

Now if i click on "View Report as XLS" option from eclipse,then I am able to 
see the image in excel file. when i call the report from a java page,then the 
image is getting displayed in the BIRT report viewer but if I export it as 
excel from the BIRT report viewer window, then image is not getting exported in 
the excel file.

What version of the product are you using? On what operating system?
BIRT 3.7
Windows

Please provide any additional information below.

Original comment by abhijit....@gmail.com on 19 Apr 2012 at 5:17