• Home
• DevShare
  • All Topics
  • Designing BIRT Reports
  • Deploying BIRT Reports
  • Spreadsheet Automation
  • Ad-Hoc & Interactive Reporting
  • Using BIRT with Rational
  • Using BIRT with Maximo
  • Contribute to DevShare...
• Forums
  • Designing BIRT Reports Forums
    • Designing BIRT Reports
    • Eclipse BIRT Newsgroup Mirror
  • Ad Hoc & Interactive Reporting Forums
    • Ad Hoc & Interactive Reporting
  • Spreadsheets in Java Forums
    • Designing e.Spreadsheet Reports
    • Integrating e.Spreadsheet Engine and Deploying e.Spreadsheet Reports
  • Deploying Reports Forums
    • Deploying and Integrating BIRT Report Engine in Applications
    • Deploying BIRT Reports in iPortal or iServer Express
  • Applications Using BIRT Forums
    • Using BIRT with IBM Rational Tools
    • Using BIRT with Maximo
  • General Forums
    • BIRT Exchange Announcements, Help and Feedback
    • General Discussion
    • Practice Area
• Wiki
• Products & Services
  • Product Overview
  • BIRT Reporting
    • Overview
    • BIRT Report Designers
    • BIRT Engine
    • BIRT Deployment Kit
    • BIRT Report Server
  • Spreadsheet Automation
    • Overview
    • Spreadsheet Report Designer
    • Spreadsheet Engine
    • Deployment Kit
    • Spreadsheet Report Server
  • Ad-Hoc & Interactive Reporting
    • Overview
    • Interactive Viewer for End Users
    • BIRT Designer for End Users
  • Services & Support
    • Overview
    • Professional Services
    • Support Services
    • Training
  • iServer Express
  • How to Buy...
• Downloads
  • Overview
  • BIRT Report Designers
  • BIRT Report Deployment
  • Spreadsheet Automation
  • Ad-Hoc & Interactive Reporting
• Documentation
  • All Products
  • BIRT Report Designers
  • BIRT Report Deployment
  • Spreadsheet Automation
  • Ad-Hoc & Interactive Reporting
• Webinars
• Store
• Blog

• Register
• Login
• About Us
• 
• Bookmark
• Print

Dismiss

Home DevShare spreadsheet-automation

e.Spreadsheet Engine Multi-Sheet Excel Report from JDBC Data Source

Designs & Code

by rmurphy

Posted Oct 08, 2007 (Edited Jul 29, 2008 )

(0 reviews, 5546 views)

Download (115.22 KB)

By downloading this item, you are agreeing to the Terms of Use for the site.

This is an e.Spreadsheet Example that creates a multi-sheet Excel document with charts from a JDBC data source.

This example demonstrates the Actuate e.Spreadsheet Engine's ability to dynamically generate a richly formatted Excel spreadsheet report and deliver it to an Excel client through a Web browser.

The Actuate e.Spreadsheet Engine API is used in a servlet to read in an e.Spreadsheet Design file (.sod). The design file defines a connection to a data source (this can also be externalized) and defines the report layout. The query defined in the design is executed and the spreadsheet is recalculated and delivered to the requesting client as a rich Excel file with formulas and formatting intact.

http://es.actuate.com/eSeExcelFromJDBC/index.html

Download (115.22 KB)

By downloading this item, you are agreeing to the Terms of Use for the site.

Post a Comment

Post a comment

Comments
Maximum 255 characters
characters left

Submit Cancel

Add a Review

Add a Review

Rating Choose one... 5 Stars 4 Stars 3 Stars 2 Stars 1 Star

Review
Maximum 255 characters characters left

Submit Cancel

Sponsored by

© 2008 Actuate, Inc. All rights reserved.

Site Map | Terms & Conditions | Privacy Statement | Contact Us

BIRT Exchange is a community site for Eclipse BIRT and Actuate BIRT developers who are adding reporting, analytics and business intelligence capabilities to Java applications. BIRT Exchange allows developers to share code samples and report designs, tutorials, technical articles, as well as tips and tricks. BIRT Exchange also offers forums, downloads, online documentation, and information on BIRT technical support.