SpreadsheetGear for .NET Standard enables developers for iOS, Android, Linux, macOS and UWP to easily take advantage of scalable Excel Reporting, comprehensive Excel compatible charting APIs, the fastest and most complete Excel compatible calculations and more using a single assembly which implements the same API employed by thousands of Windows developers for more than a decade. This library supports the Microsoft .NET Framework, ASP.NET Core, .NET Core, Universal Windows Platform, Xamarin.iOS, Xamarin.Android, Xamarin.Forms, Mono and any other platform which supports .NET Standard 1.3.

The SpreadsheetGear family of products includes SpreadsheetGear 2017 for .NET which comes with assemblies built for .NET 2.0 and .NET 4.0, SpreadsheetGear for .NET Standard which requires a platform with .NET Standard 1.3 support and SpreadsheetGear 2017 for Silverlight which requires Silverlight 5. Although most features are identical, there are some differences due to the limitations of each .NET platform.


General FeaturesGeneral Features
Royalty free deployment to 32 bit and 64 bit Windows 2000, Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Windows Server 2003 (including R2), Windows Server 2008 (including R2), Windows Server 2012 (including R2) and Windows Server 2016.
Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 97-2003 (xls) and Excel 2007-2016 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. Related Samples
Section: Calculation EngineCalculation Engine
Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel in many cases). Related Samples
Multithreaded calculations efficiently utilize todays multi-core CPUs.
Interruptible background calculation enables responsive applications.
449 Excel compatible financial, date, time, text, lookup, math, trigonometry, statistical, engineering, database, information, logical and web functions (see list here).
All types, operators, defined names, data tables and arrays.
Support for 64K worksheets and unlimited workbooks in formulas.
Worksheet specific defined names and global defined names.
Custom functions, minimal recalc, iteration, precision as displayed and more. Related Samples
Copy formulas between cells, worksheets, workbooks and workbook sets with full support for reference fixups.
Insert and delete worksheets, rows, columns and cells with full support for reference fixups.
Cut, copy and paste with full support for smart reference fixups across multiple worksheets and workbooks.
Special care was taken with numerical stability.

Workbook Features
Read and write workbooks to disk, memory streams and byte arrays.
Read and write password protected xls, xlsx and xlsm workbooks, including new Agile Encryption used by Excel 2013 and later.
Workbook and worksheet scoped named ranges.
Options to show and hide worksheet tabs and scrollbars. Related Samples

Worksheet Features
AutoFilters Related Samples
Top or bottom n items.
Top or bottom n percent.
Above or below average.
Last day, month, quarter, week or year.
This day, month, quarter, week or year.
Next day, month, quarter, week or year.
Specific day, month, year, hour, minute or second.
Year to date.
Filter by font color, interior color or conditional format icon.
Custom criteria such as ">50".
Filter by specific list of values.
Support for the SUBTOTAL function which works in conjunction with autofilters to return various statistics for filtered items including average, count, max, min, product, standard deviation, sum and variance.
Autofilter support in many commands including cell formatting, copy paste, fill, delete and more.
Drag Fill / AutoFill, including suppor for numbers, dates, times, month names, day names and certain text patterns. Related Samples
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.
GoalSeek - Fast single variable and single target goal seeking. Related Samples
Cell Data Validation - including operators, alert messages, alert styles, custom formulas and drop-down lists. Related Samples
Conditional Formatting Related Samples
Simple comparison operators
Custom formulas
Icon Sets
Data Bars
Color Scales
Highlight Cells
Top n / Bottom n Rules
Advanced Rules
Overlapping Rules
ADO.NET DataSet and DataTable Conversion Related Samples
Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
Insert, delete and clear rows, columns and cells.
Enable or disable worksheet protection, worksheet passwords and cell locking. Related Samples
Autoshapes, text boxes and pictures including JPEG, PNG, GIF, BMP, WMF and EMF.

Printing Features
Print workbooks, worksheets, ranges and charts in any combination.
Horizontal and vertical page breaks. Related Samples
Page Setup Options Related Samples
Print area, title rows and title columns.
Margins, page order, page orientation, zoom and fit to pages.
Custom headers and footers.
Print preview.
Print to XPS files.

Formatting Features
Number formats, including full support for getting and setting Excel compatible custom number formats as well as getting the formatted text of a cell as Excel would display it. Related Samples
Fonts, borders, cell interior color and gradient fills, Office theme colors with tinting and shading, RGB colors, Excel palette indexed colors and patterns. Related Samples
Horizontal alignment, vertical alignment, word wrap and rotated text. Related Samples
Merged cells, hyperlinks and conditional formats. Related Samples
Grouping and outlining of rows and columns. Related Samples
Automatic row heights and column widths.
Copy formats without affecting formulas or values.
Named cell style support.

Spreadsheet Control Features
Windows Forms, WPF and Silverlight WorkbookView spreadsheet controls provide viewing, navigation and editing support which is familiar to Excel users.
In-cell editing and optional FormulaBar control provide the ability to enter and edit cell values and formulas, including support for pointing at cell references in formulas across worksheets and workbooks.
Smart data entry with optional data validation as well as automatic recognition and formatting of dates, times, percentages, currency, scientific notation and fractions will be familiar to Excel users.
Conditional formatting enables font colors, font styles, background colors, borders as well as other graphical features such icon sets, data bars, color scales and more, which are based on simple comparison operators, complex formulas or more advanced rules.
Grouping and outlining which allows users to easily expand and collapse the displayed level of detail.
WorkbookDesigner provides an MDI Windows application which may be used from within Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2013, Visual Studio 2015 and Visual Studio 2017 at design time and by your applications at run time.
WorkbookExplorer provides the ability to manipulate workbooks, worksheets and defined names as well as their properties.
RangeExplorer provides extensive modeless formatting of the currently selected range with support for number formats, alignment, fonts, borders, colors, patterns, gradients, protection options, hyperlinks, conditional formats and data validation.
ChartExplorer provides basic modeless modification and formatting of the selected chart with support for chart types and data sources, legend options, primary and secondary axes options and various series options.
Modeless find and replace dialog with support for find, find all, replace and replace all.
Support for an unlimited number of workbooks associated with each WorkbookView.
DisplayReference and DisplayReferenceName properties allow complete control over what appears for each sheet tab, including the ability to make multiple workbooks appear as one workbook and the ability to specify dynamically changing ranges using worksheet functions such as OFFSET().
Cut, copy, paste and paste special support including rich data and formatting interchange with Excel and full formula fixups.
Frozen rows and columns, split panes, sheet tab colors, zoom, multi-level undo/redo, autofit rows and columns, goto, clear, printing, print preview, interruptible background calculation, real time workbook updates and more.
CommandManager provides the ability to add custom undoable commands as well as the ability to override the behavior of common commands.
Full integration with Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2015 and Visual Studio 2017, including the ability to use the WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer and ShapeExplorer at design time and at runtime.
SpreadsheetGear Explorer Sample Solutions for Windows and Silverlight provide source code which demonstrates commonly used features and APIs.

Microsoft .NET Framework Features
Easy to use API which will be familiar to Excel VBA and COM developers while taking advantage of .NET's expressiveness.
Supports 32 and 64 bit versions of the Microsoft .NET Framework 2.0, .NET 3.0, .NET 3.5 .NET 4.0, .NET 4.5, .NET 4.6, .NET 4.7 and Silverlight 5.
Supports 32 and 64 bit versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Windows Server 2003 (including R2), Windows Server 2008 (including R2), Windows Server 2012 (including R2) and Windows Server 2016.
Microsoft Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2013, Visual Studio 2015 and Visual Studio 2017 integration, including IntelliSense and Dynamic Help.
The security of 100 percent safe managed code which does not require FullTrust.
Hassle free deployment with strong named assemblies as well as no license keys, registry entries or configuration issues.
No dependency on Microsoft Excel, which is not supported in a server environment.

Only for V.I.P