GemBox.Spreadsheet supports multiple spreadsheet file formats and a lot of MS Excel features and can substantially improve your application's performance and remove dependency on Excel Automation.
Following is a more detailed list of GemBox.Spreadsheet features.
Read Microsoft Excel (XLSX, XLS, ODS) files, textual files (CSV, TXT) and HTML files.
Write / create and convert to XLSX, XLS, ODS, CSV, TXT, HTML, PDF, XPS and image formats.
View and edit spreadsheets in WPF, ASP.NET, ASP.NET Core and Windows.Forms applications.
Print spreadsheets or
Protect, encrypt and digitally sign spreadsheets.
Get, create or edit sheets, rows, columns, cells, formulas, hyperlinks, comments, images, charts, shapes, text boxes, tables and pivot tables.
Get, create or edit cell styles and formatting, in-line text formatting and conditional formatting.
Get, create or edit headers and footers, grouping and outlining, data validation, sheet protection, document properties, print and view options.
Get, create or edit row height and column width, print titles and area and freeze or split panes.
Import or export spreadsheet data from/to a DataTable.
Search, filter or sort spreadsheet data.
Preserve unsupported elements including illustrations, certain charts, macros, smart arts, sparklines and slicers.
Medium trust support.
Different file formats have different level of support. Therefore, for file formats that you require, you should check if our current implementation supports features that you need.