Pagos Spreadsheet Component allows software developers to create web and desktop applications that can read, execute, and create Excel spreadsheets without requiring Microsoft Excel. Pagos Spreadsheet Component interprets the formulas and data in Exc
Pagos Spreadsheet Component allows fast and reliable server-side usage of Excel spreadsheets with read, execute, and write capabilities. The component doesn't require user intervention and allows multiple users to access the same workbook. The engine loads the file into the memory without locking it which makes it possible to have several instances open at the same time.
Pagos Spreadsheet Component is available for .NET, COM, and Java.
Pagos Spreadsheet Component provides superior performance running even the most complex Excel applications and because it is designed and developed for high speed server side use, advanced optimization techniques have been applied. Using deferred calculation and dependency maps, component ensures maximum performance. Commonly used functions such as IF, VLOOKUP, and HLOOKUP are further optimized.
Pagos Spreadsheet Component accepts XML documents as input and returns XML documents as output. It is a preferable alternative to directly calling cells in your code to build more scalable solutions
Maintains the integrity of Excel spreadsheets:
Unlike most products in the market, Pagos Spreadsheet Component keeps your files in Excel rather than converting them into a different format. It provides business users the control to update the calculations and logic residing in Excel when needed.
Excel Compatible Calculation Engine:
Pagos Spreadsheet Component supports 300 of the most common Excel functions and because it is designed to handle very large and complex spreadsheet engines, every effort was made to match the results calculated by Excel. For this purpose, it has an internal testing facility to compare its calculated values to the ones calculated by Excel. This testing facility can be used by the end-user to test if the Excel spreadsheet is fully compatible. List of supported Excel functions
Excel Compatible Reporting Engine:
It is possible to generate and edit Microsoft Excel compatible files. It allows software developers to integrate Pagos Spreadsheet Component with their web or desktop applications as a high performance reporting engine. Its API covers most Excel features.
Compatible API with Microsoft VBA:
Pagos Spreadsheet Component has a compatible object library with Microsoft VBA. This makes it easier for developers familiar with VBA object library to create applications using Pagos Spreadsheet Component or convert existing Excel automation programs to work with it.
Easy Configuration and Use:
Pagos Spreadsheet Component is a self registering component and doesn't require any configuration. Therefore, It is ready to use after installation and is added to the "reference dialog" of Visual Studio.NET automatically. Its simple COM, .NET, and Java API makes using Pagos Spreadsheet Component very easy.
You can build your application by implementing spreadsheet calculations as independent transactions using Pagos Spreadsheet Component. This allows for maximum scalability and flexibility for load balancing. It is easy to scale up an application by adding new servers to the farm.