Platforms
Spire.XLS for .NET enables developers/programmers to build ASP.NET, Web Services, WinForms or any other type of application for any .NET Framework version from 2.0 to 4.5, .NET 5.0, .NET 6.0, .NET core, .NET Standard, MonoAndroid and Xamarin.iOS. Full support for 32-bit and 64-bit system.
File Format Supports
Spire.XLS for .NET supports lots of file formats.- Spire.XLS for .NET offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format.
- Save as HTML is available.
- Load and save documents in the tab delimited file format.
- Comprehensive support of the CSV format to interact with a variety of applications.
- Easily extract text by saving in plain text format.
Conversion
Spire.XLS for .NET 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 to XPS
- Excel to SVG
Contents Features
Spire.XLS for .NET offers a wide range of features and the main features are listed as below:- Create and Edit Excel
- Find and Replace Data
- Print excel files
- 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
Formatting Features
Spire.XLS for .NET 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.
Page Setup Features
Spire.XLS for .NET 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
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 |