Pagos Spreadsheet組件能幫助軟件開始者在無需使用Microsoft Excel的情況下,能進(jìn)行讀取、執(zhí)行以及創(chuàng)建Excel表單的網(wǎng)絡(luò)以及桌面應(yīng)用程序。通過Pagos Spreadsheet,用戶可將其基于Spreadsheet的所有工具及模型轉(zhuǎn)化為企業(yè)級應(yīng)用程序,其可與用戶的其他企業(yè)應(yīng)用無縫連接,或者為之創(chuàng)建一些外圍應(yīng)用。Pagos Spreadsheet組件提供了服務(wù)器端的快速可靠應(yīng)用能力,允許多用戶同時(shí)使用Excel電子表格。以下是一些典型使用了或者得益于Pagos Spreadsheet組件的應(yīng)用的應(yīng)用:基于Web的利率和報(bào)價(jià)應(yīng)用,(證券)自動(dòng)承銷解決方案,計(jì)劃/收益配置工具,風(fēng)險(xiǎn)評估程序,交易軟件,預(yù)算軟件以及統(tǒng)一預(yù)測軟件。
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.

優(yōu)異的性能
Pagos Spreadsheet控件是用C++開發(fā)的,其即使在運(yùn)行非常復(fù)雜的Excel應(yīng)用程序時(shí)均能有著極佳的性能。由于它是為用于高速服務(wù)器端而開發(fā)設(shè)計(jì)的控件,因?yàn)樵谄渲袘?yīng)用了先進(jìn)的最優(yōu)化技術(shù)。通過使用延時(shí)計(jì)算以及依賴性映射,該控件保證了最佳的性能,也進(jìn)一步優(yōu)化了諸如IF、VLOOKUP以及HLOOKUP等常用功能。
XML文件的輸入/輸出
Pagos Spreadsheet控件能接受XML格式的文件輸入,也能輸出XML格式文檔。其是一種優(yōu)秀的選擇,能幫助直接從用戶的代碼中直接調(diào)用某些單元以創(chuàng)建更具擴(kuò)展性解決方案。
保持Excel表單的完整性
與市面上的大部分產(chǎn)品不同,Pagos Spreadsheet控件會(huì)將您的文件保持為Excel格式,而不是將它們轉(zhuǎn)化為其他的格式。若有需要時(shí),它還能為用戶提供了對Excel里計(jì)算以及邏輯更新的控制。
與Excel的兼容
Pagos Spreadsheet控件支持325種Excel的常用功能,也由于它本身就是被設(shè)計(jì)用于處理大型、復(fù)雜的表單引擎,我們努力的使之與Excel的計(jì)算結(jié)果匹配。為了實(shí)現(xiàn)該目標(biāo),我們在其內(nèi)部設(shè)置了一個(gè)測試程序以比對Pagos Spreadsheet計(jì)算出的結(jié)果與Excel的結(jié)果。最終用戶可使用該測試程序檢驗(yàn)其是否完全兼容Excel表單。
與Excel兼容的報(bào)表引擎
該控件能生成及編輯與Microsoft Excel兼容的文件。其能幫助軟件開發(fā)人員將Pagos Spreadsheet控件與其web或桌面應(yīng)用程序融合,形成一個(gè)高效的報(bào)表引擎。此外,其API涵蓋了大部分的Excel功能。
圖表支持
Pagos Spreadsheet組件包含了一個(gè)高效的圖表引擎。其能讀取圖表報(bào)表以及內(nèi)嵌在工作表中的圖表,并將之保存至文件中,其還能為每一圖表在同一個(gè)工作薄中創(chuàng)建兼容Excel的圖形文件。Pagos Spreadsheet組件能支持絕大部分的Microsoft Excel圖表類型以及圖表屬性。
可在Windows, Linux, 和 Sun Solaris中應(yīng)用
Pagos Spreadsheet Component現(xiàn)在已可用于Windows2000及其以上版本,此外還可用于Linux以及Sun solaris中。
簡便的配置與使用
Pagos Spreadsheet控件是一款自動(dòng)注冊控件,并且不需要任何的配置設(shè)置。因此,它在安裝完成后就能直接使用,并且會(huì)迅速自動(dòng)添加到Visual Studio.NET的“reference dialog”中。其簡單的COM、.NET和Java API是指使用起來非常簡單。
可擴(kuò)展性
使用Pagos Spreadsheet控件,用戶可以獨(dú)立的處理模式應(yīng)用表單計(jì)算,以創(chuàng)建其應(yīng)用程序。這使加載平衡實(shí)現(xiàn)了相當(dāng)?shù)目蓴U(kuò)展性以及靈活性。控件的多線程架構(gòu)使之只需向系統(tǒng)添加新的進(jìn)程即可對之?dāng)U展。使用了PSC,用戶只需通過添加新的服務(wù)器就能輕易地?cái)U(kuò)大應(yīng)用程序的規(guī)模。

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.