• Overview

    Spire.Spreadsheet for WPF is a professional spreadsheet component for WPF development. Compatible with Excel, Numbers and any other XLS-based Spreadsheet program, Spire.Spreadsheet for WPF enables developers/programmers to directly read, write, edit and customize spreadsheet files from their WPF applications.

    Spire.Spreadsheet for WPF is a standalone WPF component. Developers/programmers can directly perform a wide range of easy-to-use functions without any dependency on Microsoft Excel. It enables developers/programmers to perform operations on Excel 97-2003, Excel 2007 and Excel 2010 in C#,VB.NET.

    Main Functions

    100% Standalone Spreadsheet Program
    Spire.Spreadsheet for WPF is a totally standalone WPF component. This WPF spreadsheet component has no dependency on Microsoft Excel or any other 3rd party tools.
    Multiple Ways to View Spreadsheet
    Spire.Spreadsheet for WPF supports Excel 97-2003, Excel 2007 and Excel 2010 even when they are encrypted. Users can easily load Excel file from folder, stream and byte array. It also supports changing zoom view from 100% to 400%.
    Various Choices to Edit Spreadsheet
    Spire.Spreadsheet for WPF supports such a wide range of Spreadsheet editing features as: Customizing column and row; Managing formulas in the excel file; Run-Time Validation; insert comments in Excel; All the clipboard operations like cut, copy and paste even with formulas etc. Spire.spreadSheet for WPF also performs well on import data form Data table to Excel.
    Effortlessly Manage Spreadsheet Element
    With Spire.Spreadsheet for WPF, developers/programmers can effortlessly manage Spreedsheet elements. You can resize column width/row height and set styles & formats like: cell fonts and borders, conditional formatting, and number formatting etc. Spire.Spreadsheet for WPF also supports images, freeze panes and hyperlinks.
    Easily Customize Spreadsheet Performance
    Spire.Spreadsheet for WPF enables developers/programmers to customize Toolbar as well as optimize workbook append/load events.

    Feature Details

    Feature Support Feature Support
    Spread Load Spread Edit
    Load From File/Stream/Byte array Auto fit(Row and Column)
    Load Encrypted Excel Formula
    Excel 97~2003 (.xls),Excel 2007, 2010 (.xlsx) Data Validation
    Spread Elements Comments
    Cell Fonts Named Ranges
    Conditional Formatting Clipboard
    Number Formatting Customize Events
    Merged Cells Workbook Append Event
    Cell Border Workbook Load Event
    Hyperlink Spread View
    Resize Row and Column Zoom In/Out *
    Insert Image Toolbar Customize
    Freeze panes Open/Zoom/Print *

    Screenshots