nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multisheets in birt runtime SP3

XFabien

Hello,

Is it possible to generate the rapport to XLS with multisheets by the Actuate birt SP3 runtime?

I know that we can export the report to XLS with multisheets by the Web Viewer, but I want to set this value to my framework.

Thanks to you all.

Find more posts tagged with

Comments

Clement Wong

For every page rendered, the Actuate Excel Emitter will generate a new Excel sheet unless specified. 
 
The Actuate BIRT Engine Runtime for Excel Export sets the multiple sheet option to true by default. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>ConfigurableOption multipleSheet = new ConfigurableOption("excelRenderOption.multipleSheet");
..
multipleSheet.setDefaultValue(Boolean.TRUE);</pre>
In your RunAndRender or Render task, you can set the option to false, if desired: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>EXCELRenderOption options = new EXCELRenderOption();
options.setOption ("multipleSheet", false);
task.setRenderOption(options);
</pre>
Note that it is possible to rename your exported sheets in your design. In onPageBreak, you can set the sheet name: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );</pre>

XFabien

<blockquote class='ipsBlockquote' data-author="'cwong'" data-cid="111578" data-time="1353006546" data-date="15 November 2012 - 12:09 PM">
For every page rendered, the Actuate Excel Emitter will generate a new Excel sheet unless specified. 
 
The Actuate BIRT Engine Runtime for Excel Export sets the multiple sheet option to true by default. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>ConfigurableOption multipleSheet = new ConfigurableOption("excelRenderOption.multipleSheet");
..
multipleSheet.setDefaultValue(Boolean.TRUE);</pre>
In your RunAndRender or Render task, you can set the option to false, if desired: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>EXCELRenderOption options = new EXCELRenderOption();
options.setOption ("multipleSheet", false);
task.setRenderOption(options);
</pre>
Note that it is possible to rename your exported sheets in your design. In onPageBreak, you can set the sheet name: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );</pre></blockquote>
 
Thank you very much cwong. 
 
Does that means if I generate a XLS file from the engine Birt RunTime, and if I have added some page break in the report, the XLS file will be multisheets ? 
 
Thanks for the confirmation.

Clement Wong

In the Actuate commercial offering of BIRT (not open source BIRT), there are additional options available when Exporting Content to Excel -- one of those is the multi-sheet option. For every page generated, there will be a corresponding sheet. As previously mentioned, you have the ability to disable if required.

Regards,
Clement Wong
Actuate Corporation