Pagos Spreadsheet Component (PSC) - for Java Lite Edition - V4.2 - Summary

by Pagos - Product Type: Component / Java Class

Summary

Pagos Spreadsheet Component (PSC) - for Java Lite Edition - V4.2 by Pagos

Build 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 Excel by turning them into high performance calculation or reporting engines, running even the most complex Excel applications at unparallel speeds. Supports 300 Excel functions; XML input and output; maintains the integrity of Excel spreadsheets; no conversion; files remain in XLS; self registering component; no configuration needed.

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.

Superior performance:

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. Using deferred calculation and dependency maps, component ensures maximum performance. Commonly used functions such as IF, VLOOKUP, and HLOOKUP are further optimized.

XML Input/Output:

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.

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.

Scalable:

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.

What's new in V4.2

Save and edit Excel-compatible files

Insert/Delete Worksheets

Insert/Delete Rows and Columns

Insert/Delete Cells

Apply styles

Apply number formats

Apply font

Apply borders

Apply patterns

Apply alignment

What's new in V4.1

Now supports 300 Excel functions

Support for Linux (Enterprise Edition only)

Support for Sun Solaris 10 (Enterprise Edition only)

PartNumbers: PC-516280-116105 516280-116105 PC-516280-116106 516280-116106 PC-516280-116104 516280-116104 PC-516280-116107 516280-116107

PurchaseOptions: Pagos Spreadsheet Component (PSC) V4.2 for Java Lite Edition 1 Developer License , Pagos Spreadsheet Component (PSC) V4.2 for Java Lite Edition 10 Developer License , Pagos Spreadsheet Component (PSC) V4.2 for Java Lite Edition 1 Server License , Pagos Spreadsheet Component (PSC) V4.2 for Java Lite Edition 10 Server License

Resources: Read the PSC Supported Functions, Read the Pagos Spreadsheet Component help file, Read the Pagos Spreadsheet Component User Guide, Read the Pagos Spreadsheet Component License Agreement, Download the Pagos Spreadsheet Component V4.2 for Java Lite Edition evaluation on to your computer - Expires after 30 days, Download the Pagos Spreadsheet Component Java Samples

Operating System for Deployment: Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows NT 3.51

Architecture of Product: 32Bit

Product Type: Component

Component Type: Java Class

Built Using: JDK 1.1

Compatible Containers: Microsoft Visual J++ 1.1

Search Items: New Product Sep 05

Keywords: Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl Math Stats Mathematics Mathematical Statistic Statistical Financial finance bank banking insurance Business Rules Author spreadsheet excel reporting statistics mathematics