The Formula One e.Spreadsheet Engine is an innovative Pure Java solution for embedding financially based actions and functionalities into Java applications and projects.
Java Tool for Building Calculations and Excel Reporting into Financial Applications and Projects
The e.Spreadsheet Engine delivers the power and flexibility of a 100% Pure Java, Excel-compatible spreadsheet engine. You approach it as a complete collection of API-accessible Java classes that integrate seamlessly with your development environment and application server platform. Also included is a separate spreadsheet template designer that you can use to visually build report templates that are merged with dynamic data at runtime.
Altogether, the Formula One e.Spreadsheet Engine provides you with the tools you need to create powerful, 100% Pure Java reporting, budgeting, forecasting, planning, and calculations for your Java applications, Java Server Pages, servlets, or EJB.
Main Areas
The Formula One e.Spreadsheet Engine's versatility and nature as an embedded tool leads to various uses by ReportingEngines customers. However, the majority of these deployments can be classified in three main areas:
1. Excel Report Generation
Access XML or JDBC databases and deliver fully editable Excel files as a report to your business analysts and financial users. Dynamically generate these reports from your application server or through your portal with "new" data and increase the analysis and decision making power of your users with real Excel files that include formulas, outlining, charts, and other rich features included upon delivery.
2. Calculation or Business Rules Engine
Use Excel files as a basis for governing calculations and business rules in your Java projects and applications. Embedded in an application server, the Formula One e.Spreadsheet Engine can read in an Excel file, populate it with incoming data from Web forms, databases, XML, or other data sources, and perform calculations and other actions based on the formulas and functions contained in the base Excel spreadsheet. You as the Java developer no longer have to translate Excel formulas to Java code. The spreadsheet experts (business analysts, actuaries, financial gurus, etc.) continue to own the core business logic and calculations. Calculation errors and application downtime is greatly reduced.
3. Data Grids That Are Excel-Like and Excel-Compatible
Embed a spreadsheet-like interface in your applets and Java desktop applications. Users can manipulate data as if they are using Excel, including the use of Excel formulas and functions. After users make changes in your embedded grid, they can save the file to their desktop as an Excel file or commit the changes back to your server where they can be saved to a database or passed to another application.
New in Formula One e.Spreadsheet Engine Version 11
- Pivot Table Support - a PivotTable is one of Excel's most useful and widely used analytical tools for summarizing large amounts of information.
- Data Filter Support - Filtering is a quick and easy way to locate a subset of data in a list. A filter list displays only the rows that meet the criteria you specify for a column.
- Support for Customer Data Sources, enhanced support for XML Data Sources, and Support for SAP R/3 and SAP Business Warehouse Data Sources.
- Support for Excel 3D Charts.
- Additional Layers of Password Protection for enhanced Security, etc.
