What is Pagos Spreadsheet Component?
Pagos Spreadsheet Component enables developers to build applications that incorporate Excel spreadsheets for business logic, rules or calculations. It interprets formulas and data and turns the business logic expressed in an Excel file into a high performance calculation engine - without requiring Excel.
Typical applications which use and benefit from Pagos Spreadsheet Component include web-based rating and quoting applications, automated underwriting applications, plan/benefit configuration tools, risk assessment applications, trading software, budgeting applications and consolidated forecasting.
Benefits
- Accelerate application development.
- Reduce project costs.
- Shorten testing/retesting cycles.
- Improve accuracy of business logic and calculations.
General Features
- Read, write, and execute Excel 97+ spreadsheets without Microsoft Excel.
- Supports Windows, Linux, and Sun Solaris platforms.
- Provides small and easily understandable interfaces for COM, .NET and Java applications.
- Integrates into Visual Studio .NET 2003 and Visual Studio 2005.
- Provides XML access to Excel worksheets.
- Supports MTA (COM interface) and multithreaded applications (.NET and Java interface).1)
Calculation Features
- High performance spreadsheet calculation engine.
- Supports 325 Excel formulas.
- Supports all types, operators, arrays, defined names.
- Edit formulas programmatically.
- Automatically readjust formula references when insert/delete of cells/columns/rows/worksheets.
Reporting Features
- Save Excel compatible files.
- Insert/Delete Worksheets.
- Insert/Delete Rows and Columns.
- Insert/Delete Cells.
- Apply styles on a range.
- Apply number formats on a range.
- Apply font on a range.
- Apply borders on a range.
- Apply patterns on a range.
- Apply alignment on a range.
Charting Features
- High performance chart engine.
- Supports most chart types in Excel.
- Supports most chart properties in Excel.
Other Features
- XML input/output.
- Database connectivity.
- Easy configuration and use.
- No conversion. Files remain in Excel format.
- Scalable for server applications.