The SpreadsheetGear family of products is made up of powerful and flexible Microsoft Excel compatible spreadsheet components and includes SpreadsheetGear 2017 for .NET Framework, SpreadsheetGear for .NET Standard and SpreadsheetGear 2017 for Silverlight. SpreadsheetGear enables ASP.NET, Windows Forms, WPF, iOS, Android, Linux, macOS, UWP and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

Features:

Royalty free deployment to 32 bit and 64 bit Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Windows Server 2008 (including R2), Windows Server 2012 (including R2), Windows Server 2016 and Windows Server 2019.
Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 97-2003 (xls) and Excel 2007-2019 Open XML (xlsx and xlsm) workbooks without Excel.
Scalable and reliable Excel Reporting. Related Samples
Powerful Windows Forms, WPF and Silverlight spreadsheet controls. Related Samples
Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel in many cases). Related Samples
Easily create images from Excel charts and ranges. Related Samples
Comprehensive Excel compatible charting. Related Samples
Versatile autofilters with top or bottom n items or percent, above or below average, font color, cell color, conditional format icon, custom criteria, sorting, SUBTOTAL and more. Related Samples
Read and write password protected xls, xlsx and xlsm workbooks, including new Agile Encryption used by Excel 2013 and later.
Read and write CSV and tab separated text files.
Support for cell comments, pictures, text boxes, check boxes, drop-downs, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.
Drag Fill / Auto Fill including support for numbers, dates, times, month names, day names and certain text patterns.
Fill Data Series support including automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends. Related Samples
Fast single variable and single target goal seeking. Related Samples
Data validation including operators, alert messages, alert styles, custom formulas and drop-down lists. Related Samples
Conditional formats with support for simple comparison operators and custom formulas. Related Samples
Copy and insert DataTables into pre-formatted ranges with complete formula, border and format fixups. Related Samples
Easily convert entire workbooks or specific ranges to a DataSet or DataTable. Related Samples
Copy, transpose and consolidate across cells, worksheets, workbooks and workbook sets.
Insert, delete and clear rows, columns and cells.
Stable sort with an unlimited number of keys and the ability to sort text as numbers. Related Samples
Grouping and outlining of rows and columns. Related Samples
Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
Copy, insert and move entire worksheets. Related Samples
Reads and writes VBA Macros.
A wide variety of C# and Visual Basic samples including live ASP.NET and Silverlight samples.

Only for V.I.P