Here is a brief summary of Free Spire.Doc for .NET features.
Platforms
Free 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. Full support for 32-bit and 64-bit system.
File Format Supports
Free Spire.XLS for .NET supports lots of file formats.- Free 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.
- 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
Free Spire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.- Excel to XML
- Excel to Image
- Excel to Text
- Excel to PDF
Contents Features
Free 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
- 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
Free 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, 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
Free 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 |