Multiple File Formats
Use a single programming interface for multiple file formats (XLSX, XLS, ODS, CSV, HTML, PDF, and XPS).
Standalone .NET Component
Not dependent on Microsoft Excel; 100% managed code (C#); follows .NET class library design guidelines.
Read, write, view, and edit spreadsheets in .NET Framework, .NET Core, Mono and Xamarin.
Read and write 1M rows with less than 512MB RAM, or create 1000 small files in less than 3 seconds.
Edit sheets, cells, styles and formatting, formulas, images, charts, pivot tables, protection, etc.
High quality rendering and printing, formula calculation engine, medium trust support, and more.
GemBox.Spreadsheet is a .NET component that enables you to read, write, edit, convert, and print spreadsheet files from your .NET applications using one simple API.
With GemBox.Spreadsheet you get a fast and reliable component that’s easy to use. It requires only the .NET framework, so you can deploy your application easily without having to think about other licenses. And it’s up to 250 times faster than Microsoft Excel automation!
- Read Excel files (XLSX, XLS, ODS) files, text 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 charts.
- Cell formula calculation engine.
- Protect, encrypt, and digitally sign spreadsheets.
- Get, create, or edit sheets, rows, columns, cells, formulas, hyperlinks, comments, images, charts, 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, and 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, shapes, certain charts, macros, smart arts, sparklines, and slicers.
- Medium trust support.