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, Excel 2010 and Excel 2013. However, .NET Framework and Visual Studio must be installed for using Spire.XLS for WPF.

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.

Features

Formats Supported

Excel 97-2003 (.xls) format, Excel 2007, Excel 2010, Excel 2013 and Excel 2016 (.xlsx) format and Open Office (.ods) format.

Conversion

Spire.XLS for WPF has powerful conversion ability and it enables converting Excel files to most common and popular formats.

Excel to HTML/XML/CSV
XML/CSV to Excel
Excel to Image
Excel to Text
Excel to PDF
Excel sheet to EMF image

Page Setup

Spire.XLS for WPF enables developers/programmers to set PageSetup options.

Adjust your page orientation, scaling, paper size.
Specify your margins and page centering.
Create or edit your header and/or footer with image.
Set print area, print titles, or turn on gridlines etc.
Managing Page Breaks.

Document Operation and Data Processing

Spire.XLS for WPF supports a large range of operations on Excel sheet.

Create and Edit Excel
Load an existing Excel file from template
Find and Replace Data
Import/Export data from a DataTable, DataView, Array, DataGrid etc.
Save Excel to file/Stream or as web response
Create charts
Read and write hyperlinks
Create auto filters
Implement Data Sorting
Implement Data Validations
Merge/Unmerge Cells and files
Group/UnGroup Rows and Columns
Insert/Delete or Hide Rows, Columns and Sheets
Calculate Complex Excel Formula
Freeze/Unfreeze Panes
Insert Hyperlinks to link data
Protect/Unprotect Worksheets
Create Pivot Tables
Encrypt/Decrypt Files
Load/Save Excel VBA
Merge data into Excel with MarkerDesigner

Set Formatting

Spire.XLS for WPF provides detailed programmatic access to formatting properties of all spreadsheet elements.

Apply all characters formatting in the cells including fonts, colors, effects, fill and shading.
Apply all the Number Format Settings (supported in MS Excel) for the cells.
Set all types of Text Alignment settings.
Apply different kinds of Font Settings for the cells.
Apply different Colors to Cells, Fonts, Gridlines, Graphic objects etc.
Apply different Rich Text formatting in a single cell.
Apply different Border Settings on cells.
Apply different Background Patterns on cells.
Apply gradient Background Patterns on cells.
Apply Format Settings on a Worksheet, Row, Column or a range of cells etc.
Only protect the file via the password.

Quick Navigation;