為什么選擇Spread for ASP.NET表格控件？

中文支持

Spread for ASP.NET已經(jīng)加入中文資源，同時提供中文演示程序、中文文檔和中文教程。此外，不斷豐富的中文示例庫更方便的讓您了解Spread的功能和使用場景。

全面的Excel兼容性

Spread會獨立安裝Excel文件格式的輸入輸出引擎，在沒有安裝Excel的環(huán)境中也可以進(jìn)行Excel文件格式的輸入輸出，開發(fā)時設(shè)計的圖表、圖形、圖像等都會作為對象輸出到Excel文件中。Spread提供多種版本的Excel和多種文件類型的導(dǎo)入導(dǎo)出服務(wù)，包括Excel文件（XLS、XLSX）、檔案文件（CSV）和文本文件（TXT）。

豐富的圖表

Spread支持85種豐富多彩的圖表效果。基于工作表的數(shù)據(jù)直接生成圖表，操作簡單。同時，軟件人員還可以在Visual Studio設(shè)計環(huán)境中定制圖表的所有元素，包括標(biāo)題、序列、軸、樣式、圖例等。

強(qiáng)大定制能力

Spread for ASP.NET表格控件對象模型允許ASP.NET開發(fā)者自定義界面元素同時管理控件行為。開發(fā)者通過Spread for ASP.NET表格控件將兼容Microsoft Excel的表格控件功能植入ASP.NET應(yīng)用系統(tǒng)中。

自由使用的公式引擎

Spread表格控件強(qiáng)大的公式計算引擎支持300多種內(nèi)置函數(shù)，并支持通過內(nèi)置函數(shù)和運(yùn)算符來自定義公式。支持的函數(shù)包括日期、時間函數(shù)、工程計算函數(shù)、財務(wù)計算函數(shù)、邏輯函數(shù)、數(shù)學(xué)和三角函數(shù)、統(tǒng)計函數(shù)、文本函數(shù)等。同時支持自定義各種專業(yè)公式。

特性與亮點

對AJAX的支持

通過設(shè)置EnableAjaxCall屬性提供對AJAX的支持。該設(shè)置將影響包括分層視圖中子表的分組、列排序、行插入、分頁、搜索、篩選和公式更新等功能。 如果ClientAutoCalculation 屬性的值為真， 在某個單元格的值變化后， Spread控件將收到來自AJAX的一個調(diào)用，Spread控件將會依據(jù)表單的計算公式重新計算表單并將結(jié)果發(fā)送到客戶端，最后Spread控件會在客戶端對數(shù)值進(jìn)行更新。 詳細(xì)內(nèi)容請閱讀“評估和下載"一節(jié)的“用AJAX和Spread for Web Forms對Web應(yīng)用程序進(jìn)行優(yōu)化”白皮書。

對MS Excel的支持

支持與MS Excel之間的數(shù)據(jù)導(dǎo)入、導(dǎo)出，包括數(shù)據(jù)格式和計算公式的導(dǎo)入和導(dǎo)出，同時也支持單個工作表和整個工作簿的導(dǎo)入、導(dǎo)出。服務(wù)器端支持在未安裝Excel的情況下，通過Spread控件來顯示Excel文件。

行篩選

通過行篩選，用戶可以對一個表內(nèi)的數(shù)據(jù)列中的數(shù)據(jù)進(jìn)行篩選，并且只顯示滿足下拉列表內(nèi)的標(biāo)準(zhǔn)的數(shù)據(jù)行，或在篩選的基礎(chǔ)上改變行的外觀。客戶可對篩選條件進(jìn)行定制。

凍結(jié)行& 列

支持對定義的行或列進(jìn)行凍結(jié)，使得無論如何導(dǎo)航，這些行或列都始終顯示，即在使用滾動條或?qū)Ш芥I時，凍結(jié)的行和列不會滾動。行和列的凍結(jié)目前只支持微軟IE5.5及以上版本。

分組

支持對數(shù)據(jù)進(jìn)行MS Outlook風(fēng)格的分組。

分層視圖

支持?jǐn)?shù)據(jù)分層顯示，使得數(shù)據(jù)編輯變得更簡便。通過對HierarchicalView屬性的設(shè)置完成對數(shù)據(jù)的分層顯示。支持對子層數(shù)據(jù)顯示的客戶定制，比如隱藏列、改變顏色等，還支持在分層視圖和父行視圖中進(jìn)行選擇。

導(dǎo)入和導(dǎo)出

Spread for ASP.NET表格控件支持多種數(shù)據(jù)格式的的導(dǎo)入和導(dǎo)出。 支持MS Excel 97和更高版本的文件格式、文本文件(用逗號分隔, 標(biāo)簽分隔等)、以及Spread文件。

交互

支持對分頁和菜單命令欄進(jìn)行客戶定制。

按需載入

可通過對初始數(shù)據(jù)載入量的設(shè)置，提高系統(tǒng)效率，即用戶向下滾動時，再將需要顯示的數(shù)據(jù)加載進(jìn)來。這個設(shè)置在控件級和表單及都支持。

移動列

Spread for ASP.NET表格控件通過對AllowColumnMove屬性的設(shè)置，完成象MS Excel 列移動一樣的列移動，即允許用戶點擊列的表頭并將其拖動到工作表的另一個位置。
可通過對初始數(shù)據(jù)載入量的設(shè)置，提高系統(tǒng)效率，即用戶向下滾動時，再將需要顯示的數(shù)據(jù)加載進(jìn)來。這個設(shè)置在控件級和表單及都支持。

操作模式

支持設(shè)置用戶與表單之間的交互模式：

• Normal - 默認(rèn)的工作表選擇和編輯功能

• ReadOnly - 只能查看數(shù)據(jù)，不允許在表中選擇或編輯任何單元格

• RowMode - 只允許用戶選擇單行（高亮顯示）并且只能對該行的單個單元格進(jìn)行編輯

• SingleSelect - 只允許用戶選擇單行（高亮顯示），但不能編輯任何單元格

• MultiSelect - 允許用戶在工作表中選擇多個連續(xù)的在一起的行

• ExtendedSelect - 允許用戶在工作表中選擇多個非連續(xù)行

性能優(yōu)化

Spread for ASP.NET表格控件的默認(rèn)特性使得在線發(fā)布信息變得非常簡單。 然而，在對大量的數(shù)據(jù)進(jìn)行操作時可能會需要對Spread控件的行為進(jìn)行精細(xì)調(diào)整。 Spread for ASP.NET提供了多種可極大提高程序的性能和減小下載頁面尺寸的方法：

• 風(fēng)格表

• 狀態(tài)管理

• 面向模型的編碼而不是面向幫助對象的編碼

• 命名風(fēng)格

訂單輸入范例

Spread for ASP.NET表格控件特別適合用于所有內(nèi)部的在線訂單輸入或外部的購物車。 在選擇一個ID后，Spread for ASP.NET表格控件會向服務(wù)器運(yùn)行一個AJAX調(diào)用，在服務(wù)器端收集需要的信息,然后將需要的數(shù)據(jù)傳回Spread中所有過程無需對整個頁面進(jìn)行刷新。 還可以再次調(diào)整價格、折扣或數(shù)量，Spread會運(yùn)行一個AJAX調(diào)用并對數(shù)據(jù)進(jìn)行相應(yīng)的更新。 看，會給你增加多少新的機(jī)會！

搜索

可以通過設(shè)定工作表和待搜索字符串，在工作簿中的任何單元格中進(jìn)行數(shù)據(jù)搜索。更支持多個搜索選項。

多工作表

每個Spread for ASP.NET表格控件可包含多個工作表，與微軟的 Excel類似，可方便地在網(wǎng)頁上組織、顯示信息。 支持在設(shè)計階段或運(yùn)行階段增加或刪除工作表，支持為每個表單設(shè)置背景色、網(wǎng)格線、"皮膚"。 還支持在運(yùn)行階段隱藏或顯示工作表。

設(shè)計器

Spread for ASP.NET表格控件提供功能強(qiáng)大的Spread設(shè)計器。在無需編程的前提下，通過這個有著友好用戶界面的設(shè)計工具，對Spread控件的進(jìn)行快速設(shè)置，達(dá)到所見即所得的目的。

非綁定模式

如果采用了MS Grid，則必須在綁定模式下運(yùn)行；Spread for ASP.NET表格控件提供對非綁定模式的支持。

Spread for ASP.NET軟件環(huán)境

Spread for ASP.NET is a complete ASP.NET spreadsheet component that supports bound or unbound modes (no dataset needed), AJAX, native Microsoft Excel import/export, in-cell editing, multiple edits on multiple rows without server round trips, client-side column/row resizing, multiple sheets, searching, filtering, multiple cell types, validations, cell spans, multiple headers, sorting, complete customization at the cell level, over 300 built-in calculation functions, hierarchical display and much more.

Excel Compatibility

You can import data from and export data and formatting to Microsoft Excel in its native format, both individual spreadsheets and entire workbooks. You can save data to an Excel-formatted (BIFF8 format) file or stream. There are several SaveExcel methods each with several options. For instance, you can specify whether headers are saved with the data using the setting of the IncludeHeaders enumeration. You do not need Excel on the server for Spread to display your Excel files.

AJAX Support

AJAX allows the component to refresh without refreshing the entire page. You can add AJAX support to the FpSpread component by setting the EnableAjaxCall property. This affects several features including expanding and collapsing child sheets in a hierarchical display, column sorting, inserting rows, and paging. If the ClientAutoCalculation property is true, then after a cell value is changed, an AJAX call is made to the FpSpread component. Then the component calculates the formulas and sends the values to the client side. The component then updates the values at the client side.

Filtering

You can customize the user experience for filtering data on a sheet. With row filtering, you can allow the user to filter the data in columns on a sheet and display only the rows of data which meet criteria from a drop-down list or change the appearance of rows based on that filtering. You can use the basic default filtering or you can customize practically every aspect of the filtering.

Hierarchy

Spread makes it easy to display and edit your hierarchical data. Simply set up your dataset with relations and set the HierarchicalView property to True. That’s all it takes to display your data. You have full customization at the child level if you want to hide columns, change colors, etc. You can also choose from two hierarchy views: Hierarchical View and Parent Row View.

Spread Designer

Spread includes our robust Spread Designer, a user-friendly design-time environment that allows you or your web designers to quickly configure the look and feel of the Spread control with no coding required.

You can easily assign cell types, color, text, etc for any cell using the Spread Designer’s unique WYSIWYG implementation. This allows for faster design of your applications by your developers or you can even give the Spread control to your graphic designers to configure and create “skins?Ethat can be used across multiple spreadsheets or even across multiple applications for a consistent look. Below is a screenshot of the Spread Designer:

Searching

You can search for data in any of the cells in the workbook by specifying the sheet and the string of data for which to search. You also have several searching options you can choose from.

Load on Demand

You can now allow the Web page to load on demand -- as the user scrolls further down the spreadsheet the FarPoint Spread component on the client loads another page of rows from the server as needed. This is similar to what would was called "virtual mode" in the COM version of the product. You can specify the number of rows to load initially and how many to load in subsequent loads. You can specify those properties at the component level (for FpSpread) or at the sheet level.

Conditional Formatting

You can set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional statement. You can use a named style to specify various formatting options such as borders and colors to apply if the condition statement is valid, that is, if the operation is satisfied. For example, you may want to change the background color of a cell based on the value of the cell. If the value is below 100 then the background color would be changed to red. The condition statement is “less than 100” and consists of a comparison operator “less than” and a condition, in this case a single constant “100”. The condition can be a constant (expressed as a string) or an expression. Some condition statements have two conditions and an operator: for instance, if the cell value is between 0 and 100, then change the background color. In this case, the comparison operator is “between” and the first condition is 0 and the last condition is 100. For a complete list of operations, refer to the ComparisonOperator enumeration.

Formulas

Spread includes a powerful calculation engine that allows you to quickly add formulas to your web applications by using any of over 300 pre-defined functions or you can add your own custom functions. Spread also supports cross-sheet formula referencing. In the below sample, formulas are in the 'Total Due' column and the last totals row. Enter or change a formula in a cell - "=SUM(A1:A3)" - then press the Update image link (the checkbox at the bottom left of Spread) to view your changes.

Grouping

You can set up the display to allow Outlook-style grouping of rows. For large amounts of data, this can be helpful to display the data in the order the user needs it. To select a column by which to group and display that data, either double-click on the header of that column or click and drag the column into the grouping bar at the top of the page. You can proviate multiple levels of groups by dragging additional column headers into the grouping area, set up the display so that the items are shown initially as expanded or collapsed or set the colors and other formatting of both the hierarchy names and the data in the rows when grouping is performed. Drag a column header to the grouping bar or double-click a column header to begin.  Double-click a column header to begin a new group:

Frozen Rows & Columns

You can freeze columns and rows and keep them displayed regardless of where the user navigates in the sheet. Frozen rows and frozen columns do not scroll when the user uses the scroll bar or navigation keys in the component. This is useful if you need information in non-header rows or columns to stay visible regardless of where in the sheet the user navigates. Frozen rows and frozen columns are currently only supported with Microsoft Internet Explorer (IE) 5.5 and higher.

Cell Types

Spread includes 18 cell types that help make it easier for your user to enter the data you are expecting.

Operation Modes

You can customize what the user can select by working with the operation mode of the sheet. By default, the component allows users to select a cell, a column, a row, a range of cells, or the entire sheet. The MultiRangeSelection property allows the user to select multiple discontiguous blocks with the control (Ctrl) key and the mouse.

Cell Merging

You can have Spread automatically merge cells between columns or between rows if the cells have the same value based on the policy that you set. The control can automatically combine cells that have the same contents. You might want to do this for easier viewing of the data, for example, when bound to a database. Unlike spanning cells, merging is an automatic feature. You tell the control which columns and rows allow cells to be combined automatically, and any cells within that set that have the same contents are combined for you.

Move Columns

Moving columns just got easier.You can allow your users to click on the header of a column and drag it to another location on the spreadsheet. You can set this with the AllowColumnMove property in the FpSpread class.