Spire.XLS for WPF
WPF Excel API - Well-Disigned WPF Excel API for development to read, write, modify and convert Excel files
- Overview
- Features
- Guideline
- Support
Over 1,000,000 Developers Are Already Using Our Libraries
To Create Their Amazing Applications.
To Create Their Amazing Applications.
Spire.XLS for WPF is a professional and powerful Excel API 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, Excel 2010 and Excel 2013. However, .NET Framework and Visual Studio must be installed for using Spire.XLS for WPF.
-
Convert
-
Export
-
Validate
-
Formula
-
Format
-
Chart
-
Pivot Table
-
Group
-
Merge
-
Highlight
Convert Excel to PDF
Whenever you need to share an important Excel report with a partner, it's best to convert the file to PDF to ensure it looks the same as it does on your device.
Export Data from Database to Excel
When data is exported from a database to Excel, it can be analyzed and visualized, as well as viewed and processed by users who are not database users.
Apply Data Validation
Data validation in Excel controls what kind of data can be entered into a certain cell, which ensures that all data entries are accurate and consistent.
Insert Formulas and Functions
Formula is an expression that calculates values in a cell or in a range of cells, while function is a predefined formula already available in Excel. Both formulas and functions are very useful when you need to calculate numbers or solve math problems in Excel.
Apply Conditional Formatting
Conditional formatting is a helpful feature that allows applying special formats to cells meeting specific criteria. It is often used to emphasize or differentiate data stored in worksheets.
Create a Chart
Chart is a fantastic tool to visually group and analyze data. It provides the reader with the structure of the data set and displays the data in a graphical representation, making it easier for most users to see the data.
Create a Pivot Table
Pivot table is a kind of interactive table that allow users to quickly categorize, calculate, summarize and analyze large amounts of data in a concise tabular format.
Group Rows or Columns
For worksheets with large amounts of data, grouping rows or columns that contain similar information can make the worksheet more compact and understandable.
Merge Excel Files
Merging Excel files with associated content can help us work with worksheet data more easily and also make it easier to share and read the contents of our workbooks.
Find and Highlight
You can find all cells containing a specific value and highlight them with the same background color to make the value outstanding and more easily to be found out.
MAIN FUNCTION
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.GET STARTED
Free Trials for All Progress Solutions
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 |
|
Beginners Guide is the first step towards learning the basic information of Spire.XLS for WPF |
Program Guide lists the detailed features of our Spire.XLS for WPF and you can search for the information you want. |
The Videos give an operation guide by video. You can check the produce step by step. |
|||||||||||
Main Functions contain the main features of our Spire.XLS for WPF and you can have brief information of it.
|
Frequently asked question for Spire.XLS of technical and function issues. |
We guarantee one business day Forum questions Reply. |
We guarantee one business day E-mail response. |
|||||||||||
|
Free Customized service for OEM Users. |
Skype name: iceblue.support |
Apply for a Free Trial License File. |
|||||||||||
To help you get started quickly, we offer free customized demos to our customers. Please contact support@e-iceblue.com for the free demo. Make sure the demo you want meets the below requirements.
- It relates to our components stored on E-iceblue online store.
- It costs less than 2 hours for us to complete it. If it costs more than 2 hours, please contact our sales@e-iceblue.com
If you have tried out Spire.XLS and found it useful, please consider sharing your experience with others. By sharing your testimonial with us, you will not only help others to make the right decision but will also to earn rewards from us. Please send your testimonials to sales@e-iceblue.com.