|
Excel-based Reporting and Calculations
With the e.Spreadsheet Engine, you can bring Excel's rich output as well as business logic into your Java application, using a programmatic, API-driven approach that is both flexible and powerful.
Pure Java developmentThe e.Spreadsheet Engine is an API-driven, 100% pure Java component that integrates seamlessly with your existing Java and J2EE platform. It offers more than 1,000 properties, methods, and events for generating spreadsheet output and executing Excel logic within your application. It can be used from all popular Java IDE's including Eclipse and deployed on IBM WebSphere, BEA WebLogic, JBoss, Tomcat or any J2EE application server or portal.
Leverage Excel in all aspects of your Java applicationThe e.Spreadsheet Engine brings the benefits of Excel to all dimensions of your Java application:
- Spreadsheet output - Embed data-driven, programmatically generated Excel output in your application
- Business Logic - Use on servers for managing calculations and business rules, allowing your business users to continue to build and manage complex models in Excel that you can readily leverage in your Java application
- User Interfaces - Leverage the user interface classes as an embedded, Excel-like grid in applications
Data-driven calculations, output and writebacke.Spreadsheet Engine provides the ability to access a wide range of data sources, including:
- Relational sources via JDBC
- XML data sources
- Text files
- Other server side data resources
Support for key Excel featuresThe output generated by e.Spreadsheet Engine offers a high level of Excel compatibility, with support for key Excel features including:
- All Excel worksheet functions
- Support for Excel syntax and formulas
- Pivot Tables
- Data Filters
- 2D and 3D Charts
- Conditional Formatting
- Multiple Worksheets
Rich Charting to Bring Your Application to lifeWith e.Spreadsheet Engine, you can bring all the richness of Excel's charting capabilities into your Java application. In addition to 2D charts, the product supports 3D charts, chart groups, legend item formatting, time scales, auto scaling of fonts, multi-level axis labels, and combined data labels. Supported chart types include column, line, area, step, bar, combination, pie, doughnut, XY (scatter), bubble, pie-of-pie, bar-of-pie, and stock. e.Spreadsheet Engine also features a charting API for generating Excel-compatible 2D and 3D charts programmatically from servers.
|
