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

Creating Multiple Excel sheets

Engineer

Hi,
I created a birt report and it was working fine also. But i am facing 1 problem. In my query i have 1 coloumn name "CIRCLE" and i want to create different excel sheets with respect to different circle name.And i want generation of excel sheets in single running of report.

Please provide me solution for above mention problem.

Thanks & Regards
Ankit

Find more posts tagged with

Comments

mwilliams

Hi Ankit, 
 
Out of the box, BIRT does not have the ability to write to multiple sheets in Excel. You'd have to re-write the XLS emitter to be able to do that with BIRT. 
 
Actuate does have a product that is specialized for spreadsheets that does have this functionality that you could check out. It's called e.Spreadsheet. You can see the data sheets for it here: 
 
<a class='bbc_url' href='http://www.actuate.com/products/e-spreadsheet/'>e.Spreadsheet Reporting Tools from Actuate</a> 
 
Actuate BIRT 11 will have new features for the XLS output. I don't see multiple sheets listed as of yet, but that may change. You can see some of the changes for A11 here: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/blog/2009-08-18/free-evaluation-program-for-actuate-11-milestones/'>Free Evaluation Program for Actuate 11 Milestones » Blog - BIRT Exchange</a> 
 
Hope this helps.