<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>
