Spire.XLS for WPF是一款強大的專業Excel組件,讓開發人員能夠用他們的WPF應用操作Excel文件。
Spire.XLS for WPF允許開發人員快速生成、編輯Excel文件。開發人員可以控制Excel的單元格、頁面設置、數據排序/篩選、圖表和公式。除此之外,開發人員還可以用這個組件從數據庫導入數據到Excel,或從Excel導出數據到數據庫。
無需Microsoft Automation,Spire.XLS使得編程更加簡單。Spire.XLS for WPF支持操作Excel 97-2003/2007/2010。但是,必須安裝有.NET框架和Visual Studio。
Spire.XLS for WPF is a professional and powerful Excel component which enables developers/programmers to operate Excel files with their WPF applications.
Spire.XLS for WPF allows developers to fast generate, edit Excel files. Developers can control Excel on cell formatting, page setup, data sort and filter, chart and formulas. Besides, developers can use this component to import data into Excel from database and export data from Excel to database.
Without Microsoft Automation, Spire.XLS makes programming more simply. Spire.XLS for WPF supports to operate Excel 97-2003, Excel 2007 and Excel 2010. However, .NET Framework and Visual Studio must be installed for using Spire.XLS for WPF.
主要功能:
直接操作Excel文檔
Spire.XLS for WPF讓開發人員能夠勝出、寫入、編輯和讀取Excel文件。開發人員可以用它設置文件屬性、打印頁面,保存Excel到流/網絡響應等。
導入/導出
Spire.XLS for WPF讓開發人員能實現數據庫與Excel之間的相互導入/導出。
格式化
Spire.XLS for WPF能格式化Excel,包括文本、對齊、單元格填充以及邊框等。
插入內容
Spire.XLS for WPF讓開發人員能夠在Excel中插入外部內容,如圖像、超鏈接、文本框、注解、公式(所有531條全部支持)、圖表(所有74類全部支持)以及數據透視表。
保護
Spire.XLS for WPF讓開發人員能夠通過加密整個工作簿或鎖定工作表來保護Excel文件,當然,也能解密和解鎖Excel文件。
其它細節

Main Functions
Directly Operate Excel Document
Spire.XLS for WPF enables developers to generate, write, edit and read Excel file. Developers can use it to set file properties, set up pages for printing, save Excel to stream/web response etc.
Importation/Exportation
Spire.XLS for WPF enables developers to import data from database/datatable to Excel. Meanwhile, data in Excel can be exported to database/datatable.
Formatting
Spire.XLS for WPF enables developers to format Excel, including text/number font, alignment, cell fill, borders etc.
Inserting Content
Spire.XLS for WPF enables developers to insert external contents in Excel, for example, image, hyperlink, textbox, comments etc. Also, developers can insert formulas (all 531 entries supported), chart (all 74 types supported) and pivot table.
Protection
Spire.XLS for WPF enables developers to protect Excel file by encrypting whole workbook or locking worksheet. It also enables developers to decrypt and unlock Excel.
Marker Designer
Spire.XLS for WPF enables developers to export data from database/datatable to a template Excel file, which has been well formatted.