Spire. XLS for WPF

Spire. XLS for WPF

Standalone WPF Excel Development Master

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.

Feature Details

Support Excel97~2003 Excel2007 Excel2010 Excel2013 Excel2016
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 Image CSV Text
Not supported in Standard Edition