Pagos Spreadsheet组件能帮助软件开始者在无需使用Microsoft Excel的情况下,能进行读取、执行以及创建Excel表单的网络以及桌面应用程序。通过Pagos Spreadsheet,用户可将其基于Spreadsheet的所有工具及模型转化为企业级应用程序,其可与用户的其他企业应用无缝连接,或者为之创建一些外围应用。Pagos Spreadsheet组件提供了服务器端的快速可靠应用能力,允许多用户同时使用Excel电子表格。以下是一些典型使用了或者得益于Pagos Spreadsheet组件的应用的应用:基于Web的利率和报价应用,(证券)自动承销解决方案,计划/收益配置工具,风险评估程序,交易软件,预算软件以及统一预测软件。
Pagos Spreadsheet Component allows software developers to create web and desktop applications that can read, execute, and create Excel spreadsheets without requring Microsoft Excel.With Pagos Spreadsheet Component spreadsheet-based tools and models can be turned into enterprise-level applications. They can be connected seamlessly to other enterprise applications, or new applications can be created around them. Pagos Spreadsheet Component allows fast and reliable server-side usage of Excel spreadsheets with multiple user access.Typical applications, which use and benefit from Pagos Spreadsheet Component, include web-based rating and quoting applications, automated underwriting solutions, plan/benefit configuration tools, risk assessment applications, trading software, budgeting applications and consolidated forecasting.
优异的性能
Pagos Spreadsheet控件是用C++开发的,其即使在运行非常复杂的Excel应用程序时均能有着的性能。由于它是为用于高速服务器端而开发设计的控件,因为在其中应用了*的化技术。通过使用延时计算以及依赖性映射,该控件保证了的性能,也进一步优化了诸如IF、VLOOKUP以及HLOOKUP等常用功能。
XML文件的输入/输出
Pagos Spreadsheet控件能接受XML格式的文件输入,也能输出XML格式文档。其是一种优秀的选择,能帮助直接从用户的代码中直接调用某些单元以创建更具扩展性解决方案。
保持Excel表单的完整性
与市面上的大部分产品不同,Pagos Spreadsheet控件会将您的文件保持为Excel格式,而不是将它们转化为其他的格式。若有需要时,它还能为用户提供了对Excel里计算以及逻辑更新的控制。
与Excel的兼容
Pagos Spreadsheet控件支持325种Excel的常用功能,也由于它本身就是被设计用于处理大型、复杂的表单引擎,我们努力的使之与Excel的计算结果匹配。为了实现该目标,我们在其内部设置了一个测试程序以比对Pagos Spreadsheet计算出的结果与Excel的结果。最终用户可使用该测试程序检验其是否*兼容Excel表单。
与Excel兼容的报表引擎
该控件能生成及编辑与Microsoft Excel兼容的文件。其能帮助软件开发人员将Pagos Spreadsheet控件与其web或桌面应用程序融合,形成一个高效的报表引擎。此外,其API涵盖了大部分的Excel功能。
图表支持
Pagos Spreadsheet组件包含了一个高效的图表引擎。其能读取图表报表以及内嵌在工作表中的图表,并将之保存至文件中,其还能为每一图表在同一个工作薄中创建兼容Excel的图形文件。Pagos Spreadsheet组件能支持绝大部分的Microsoft Excel图表类型以及图表属性。
可在Windows, Linux, 和 Sun Solaris中应用
Pagos Spreadsheet Component现在已可用于Windows2000及其以上版本,此外还可用于Linux以及Sun solaris中。
简便的配置与使用
Pagos Spreadsheet控件是一款自动注册控件,并且不需要任何的配置设置。因此,它在安装完成后就能直接使用,并且会迅速自动添加到Visual Studio.NET的“reference dialog”中。其简单的COM、.NET和Java API是指使用起来非常简单。
可扩展性
使用Pagos Spreadsheet控件,用户可以独立的处理模式应用表单计算,以创建其应用程序。这使加载平衡实现了相当的可扩展性以及灵活性。控件的多线程架构使之只需向系统添加新的进程即可对之扩展。使用了PSC,用户只需通过添加新的服务器就能轻易地扩大应用程序的规模。
Superior performance
Developed in C++, PSC 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, the component ensures maximum performance. Commonly used functions such as IF, VLOOKUP, and HLOOKUP are further optimized.
XML Input/Output
PSC 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, PSC 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 in Excel when needed.
Excel Compatible
PSC supports 325 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, PSC 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.
Chart Support
Pagos Spreadsheet Component includes a high performance charting engine. It allows accessing chart sheets and charts embedded in worksheets and to save them to files. It can produce Excel-compatible image files for each chart in a workbook. Most Microsoft Excel chart types and chart properties are supported.
Available for Windows, Linux, and Sun Solaris
Pagos Spreadsheet Component is now available for Windows 2000 and above as well as for Linux and Sun Solaris.
Easy Configuration and Use
PSC is a self registering component and does not 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 PSC very easy.
Scalable
You can build your application by implementing spreadsheet calculations as independent transactions using PSC. This allows for maximum scalability and flexibility for load balancing. The multithreaded architecture of the component allows it to scale by adding new processors to the system. With PSC, it is easy to scale up an application by adding new servers to the farm.