Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Excel Multiple Sheets
madhavi.test
<p>Hi Team,<br>
<br>
I am trying to design report for excel format with Multiple Sheets with Birt version 4.4.2<br>
<br>
I followed the instructions like<br>
<br>
1. There should be page break on all tables and page break intervel set to "0".<br>
2. Lay out Preferences : "Auto Lay out"<br>
</p>
<p>Render options as below:</p>
<pre class="_prettyXprint">
EXCELRenderOption options = new EXCELRenderOption();
options.setOutputFormat("xls_spudsoft");
options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter");</pre>
<p> but the out put shows single sheet with two table details.</p>
<p> </p>
<p> Any and all help is much appreciated.</p>
<p> </p>
<p> </p>
<p>Thanks in Advance,</p>
<p>Madhavi</p>
Find more posts tagged with
Comments
madhavi.test
<p>This is been fixed with RunandRender task , but it's consuming lot of memory.</p>
<p> </p>
<p>Please let me know how to handle this multi page excel report with Runtask and render task.</p>
<p> </p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Any and all help is much appreciated.</span></p>
<p> </p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Thanks,</span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Madhavi</span></p>