• Overview

    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.

    New Release - Version 6.8.5
    •Access violation exception caused by allocating not enough buffer during calling the method LoadFromFile.-Fixed

    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

    High Performance

    High performance for generating Excel documents with huge number columns and rows. Superior performance support for reading and writing spreadsheet.