How to create multiple sheets in excel reports?

Hi,

How to create multiple sheets in excel reports?

Find more posts tagged with

Comments

The built-in Excel emitter is rather limited:<br />
<ul class='bbc'><li>It doesn't do multiple sheets.</li><li>It doesn't do images (or charts).</li><li>It doesn't even output a proper XLS or XLSX file.</li></ul>
<br />
The only way around these limitations is to use a different emitter.<br />
<br />
Fortunately there are quite a few Excel emitters, <a class='bbc_url' href='http://www.spudsoft.co.uk/2011/10/the-spudsoft-birt-excel-emitters/'>this blog posting</a> lists all those I'm aware of and gives details of the <a class='bbc_url' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads'>SpudSoft Excel emitters</a> that I wrote.<br />
<br />
These blog posts might also be of use:<br />
<ul class='bbc'><li>http://birtworld.blogspot.com/2010/06/birt-excel-output.html</li><li>http://birtworld.blogspot.com/2011/06/birt-37-released.html</li><li>http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html</li></ul>
Note that they recommend the Tribix emitter (I think it was the first third party Excel emmitter), but I would avoid using that if (and only if) you actually want to manipulate the output as spreadsheets afterwards (Tribix achieves very high-fidelity output by creating a lot of extra rows and columns to line things up - with the result that numbers that ought to be in the same column are sometimes not).<br />
<br />
Jim

rohitmali

Thanks

kesavulu

<p>Dear yaytay,</p><p> </p><p>Can you plese explain me how to get multiple sheets in excel report in BIRT 4.3 version</p>

kesavulu

<p>Dear,</p><p>I am able to generate report with sheet wise through BIRT 4.3, But I need to add sheet break in between two tables can you please help me how it's possible, I made query for each sheet separately.</p><p>Please find out attacthment for my requirement</p><p> <a data-ipb='nomediaparse' href='https://hotfile.com/dl/239388297/f9c4c4d/District_Consolidated_-_DEID.xls.html'>https://hotfile.com/dl/239388297/f9c4c4d/District_Consolidated_-_DEID.xls.html</a></p>

Persa

<div>Hi,</div><div> I am using BIRT eclipse 4.3.1. In my project I got multi tabbed output in Excel and assigned the name for every respective tabs.But the header page is not displayed for every tab.I need to display the Master page for every tabs.</div><div> </div><div>Anyone please help me.</div><div> </div><div>Thanks In Advance.</div><div> </div><div> </div><div>For more reference I have attached a sample design file</div>

kclark

<p>See my attached example. Instead of using a master page I added another header row to the table and merged all the cells. Then I placed your grid at the top in the new header. This should give you a header for each tab in the excel output.</p>