Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Generate excel with mulitple sheets
RepBIRT
I have to design the report and the output format is excel. The excel sheet should contain multiple sheets and each sheet should have different content.
Kindly let me know how to
1) design different design for each sheet.
2) name each sheets individually.
Find more posts tagged with
Comments
mwilliams
Try one of these. I'm not sure if they support naming the sheets, but they support multiple sheets.
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/
http://www.birt-exchange.com/be/marketplace/app-showcase/?app=102
ashish13
<blockquote class='ipsBlockquote' data-author="'RepBIRT'" data-cid="98734" data-time="1333999393" data-date="09 April 2012 - 12:23 PM"><p>
I have to design the report and the output format is excel. The excel sheet should contain multiple sheets and each sheet should have different content.<br />
<br />
Kindly let me know how to<br />
1) design different design for each sheet.<br />
2) name each sheets individually.<br /></p></blockquote>
<br />
Hi,<br />
<br />
You can give the name to each sheet by passing the name list and setting the same in OnCreate script. The sample code is below:<br />
<br />
var paramArray=reportContext.getParameterValue("workSheetNames");<br />
reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, paramArray[0] );
Yaytay
<blockquote class='ipsBlockquote' data-author="'ashish13'" data-cid="98756" data-time="1334057166" data-date="10 April 2012 - 04:26 AM"><p>
You can give the name to each sheet by passing the name list and setting the same in OnCreate script. The sample code is below:<br />
<br />
var paramArray=reportContext.getParameterValue("workSheetNames");<br />
reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, paramArray[0] );<br /></p></blockquote>
<br />
Hi,<br />
Which emitter is that for?<br />
It's not for SpudSoft (which takes sheet names from the table names).<br />
<br />
At some point I plan to write a few web pages to show the different output from all the different Excel emitters and to document how to do the common things like this.<br />
At some point...<br />
<br />
Jim
ashish13
<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="98792" data-time="1334091292" data-date="10 April 2012 - 01:54 PM"><p>
Hi,<br />
Which emitter is that for?<br />
It's not for SpudSoft (which takes sheet names from the table names).<br />
<br />
At some point I plan to write a few web pages to show the different output from all the different Excel emitters and to document how to do the common things like this.<br />
At some point...<br />
<br />
Jim<br /></p></blockquote>
<br />
Hi,<br />
<br />
You can get this using native excel emitter.<br />
<br />
Ashish
ashish13
<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="98792" data-time="1334091292" data-date="10 April 2012 - 01:54 PM"><p>
Hi,<br />
Which emitter is that for?<br />
It's not for SpudSoft (which takes sheet names from the table names).<br />
<br />
At some point I plan to write a few web pages to show the different output from all the different Excel emitters and to document how to do the common things like this.<br />
At some point...<br />
<br />
Jim<br /></p></blockquote>
<br />
Hi,<br />
<br />
I am using native excel emitter for this.<br />
<br />
Ashish
