Details
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.
Feature Details
Support |
Excel97~2003 |
Excel2007 |
Excel2010 |
Operation |
Create New Workbook |
Edit Existing Workbook |
Save to file |
Save to stream |
Save as web response |
Workbook Properties Setup |
Worksheet Print Setup |
Worksheet Copy |
Cells Data Copy |
Cells Styles Copy |
Cells Merge |
Lock Worksheet |
Unlock Worksheet |
Data Table Import |
Data Table Export |
Freezepane |
Group |
Filter |
Data Validation |
Marker Designer |
Template |
Auto Populate |
Style Copy |
Variables |
Format Cells |
Number Format |
Text Alignment |
Font |
Cell Border |
Cell Fill |
Cell Protection |
Interior |
Content |
Formula (all 531 entries supported) |
Chart (all 74 types supported) |
Image |
Pivot Table |
RichText |
Hyperlink |
Comments |
VBA |
Convert |
XML |
HTML |
Image |
CSV |
Text |
|
Not supported in Silverlight |