BIRT Spreadsheet Engine and API (formerly e.Spreadsheet Engine and API) is a collection of Java classes and APIs used by Java development and reporting teams to perform two important functions:

1.     Automate spreadsheet reporting – Present the latest data in Excel^®, enhanced with any needed Excel 
        formatting, analysis and security features.
2.     Enrich Java applications with spreadsheet functionality – Functionality ranges from reading and 
        manipulating Excel files, to leveraging the business logic defined in Excel files, to providing interactive, 
        Excel-like grid UIs.

Features and Benefits

Automated Spreadsheet Reporting

The flexible and low-cost BIRT Spreadsheet Engine and API product used in conjunction with the free BIRT Spreadsheet Designer allows organizations to develop applications which automate the widespread, time-consuming and error-prone process of manually updating business-critical spreadsheets with the latest data and securely sharing them. These applications empower end users with on-demand access to the accurate, up-to-date spreadsheets they need to support their business decisions.

• On-demand report generation – Spreadsheet reports defined in the free BIRT Spreadsheet Designer can be programmatically executed using the Spreadsheet Engine and API to deliver the latest data as analysis-ready Excel spreadsheets
• Fully-functional Excel output – Data-driven Excel output supports virtually all Excel formatting, analysis and security features, including live formulas and charts, pivot tables, outlining, data filters, multiple worksheets, conditional formatting, password protection and more
• Dynamic customization at run-time – Customize reports at generation time based on user input by using run-time parameters to control which data is included and how it should be presented
• PDF output option – In addition to native Excel 2003 and Excel 2007 output, the BIRT Spreadsheet Engine and API supports PDF output

Enrich Java Applications with Spreadsheet Functionality

BIRT Spreadsheet Engine and API can enrich Java applications with a wide spectrum of spreadsheet functionality such as reading and manipulating Excel files, leveraging the business logic defined in Excel files, building interactive, Excel-like grid UIs and more.

• Read and manipulate Excel files – Programmatically read and update Excel files or create new ones from scratch
• Leverage Excel models from Java applications – Programmatically input values into Excel spreadsheets containing complex business models, and then use BIRT Spreadsheet Engine and API to calculate these spreadsheets and extract the resulting values. This eliminates the need for re-creating the spreadsheet business model logic using Java code
• Embed Excel-like grids in Java applications – Build Java applications with interactive, Excel-like grid UIs for inputting and manipulating the data
• Charting API – Generate 2D and 3D Excel-compatible charts and embed them in Java applications. Virtually all Excel chart types are supported

---

Want to learn more?

For more information about BIRT Spreadsheet, please contact an Actuate expert at 1-800-914-2259 (US & Canada) or click here. You can also contact one of our offices worldwide.