BIRT Exchange Forum: BIRT Exchange Forum -> Create Live Excel Spreadsheets from BIRT

Jump to content


 

No Latest Open Poll.

Create Live Excel Spreadsheets from BIRT

Posted by averma  Icon, 12 August 2010 - 09:08 AM

Actuate BIRT in version 11 has a new Excel emitter that creates analysis ready live Excel spreadsheets. I have created a few videos to highlight some of these enhancements: 

Live Excel Formulas – BIRT exports calculated fields and aggregations as Excel formula and functions that enables users to perform “what-if” analysis within spreadsheet. Watch video
Editable Charts – BIRT charts are now converted to live Excel charts with an associated data sheet containing the underlying data that could be edited to see how data changes reflects back in the chart. Watch video 
Pivot Tables – BIRT crosstabs are exported as pivot tables containing the underlying data for further analysis. These pivot tables can be used to analyze the data based on different dimensions or to perform what-if analysis by altering the underlying data sheet. Watch Video 
Images – The enhanced Excel emitter also adds support for images in the Excel output. Watch Video 
Export Objects – Export the entire BIRT output to Excel or choose a specific table, chart or crosstab to export. Watch Video
Multiple Worksheets - A simple check box control enables creation of multiple worksheets. Watch Video
To download the Actuate 11 milestone builds visit http://www.birt-exch...iki/Actuate_11/

Filed in BIRT excel emitter spreadsheet



2 Comments On This Entry

Page 1 of 1

pasc Icon

16 March 2011 - 02:46 AM
looks promising.
In these examples Office 2007 is used. Are these functionalities also available in Office 2003? What about OpenOffice?

averma Icon

06 June 2011 - 11:18 AM
The files generated are compatible with Office 2003 and I believe you could open MS office documents with OpenOffice too, though I haven't checked it.
Page 1 of 1

« May 2013 »

S M T W T F S
1234
567891011
12131415161718
192021222324 25
262728293031

My Picture

0 user(s) viewing

0 Guests
0 member(s)
0 anonymous member(s)

Categories

Search My Blog

Twitter