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