Spire.XLS for WPF

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.

Spire.XLS for WPF supports to operate Excel 97-2003, Excel 2007, Excel 2010 and Excel 2013.

Key Features:

• 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.