Download SpreadsheetGear for .NET, Silverlight, .NET Standard v8.6.1

SpreadsheetGear for .NET, Silverlight, .NET Standard v8.6.1

SpreadsheetGear for .NET, Silverlight, .NET Standard v8.6.1
SpreadsheetGear for .NET, Silverlight, .NET Standard v8.6.1


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.

Excel Reporting
Excel Reporting Easily create richly formatted Excel reports without Excel from any ASP.NET, Windows Forms, WPF or Silverlight application using spreadsheet technology built from the ground up for performance, scalability and reliability.

Excel Compatibility for iOS, Android,
Cross Platform Excel Library New SpreadsheetGear for .NET Standard product enables cross platform developers to enjoy the same high performance Excel compatible reporting, charting, calculations and more relied on by thousands of Windows developers for 10+ years.

Great Looking Dashboards from
Excel Chart and Range Imaging Samples You and your users can design dashboards, reports, charts, and models in Excel or the SpreadsheetGear Workbook Designer rather than hard to learn developer tools and you can easily deploy them with one line of code.

Excel Compatible Windows Forms,
Excel Compatible Windows Forms, WPF and Silverlight Controls Add powerful Excel compatible viewing, editing, formatting, calculating, filtering, sorting, charting, printing and more to your Windows Forms, WPF and Silverlight applications with the easy to use WorkbookView controls.

Excel Charting
Excel Charting Enable users to visualize data with comprehensive Excel compatible charting which makes creating, modifying, rendering and interacting with complex charts easier than ever before.

Excel Calculations
Excel Calculations Evaluate complex Excel based models and business rules with the fastest and most complete Excel compatible calculation engine available including 449 Excel compatible functions, multithreaded recalc, array formula support and more.

SpreadsheetGear Features
The SpreadsheetGear family of products is made up of powerful and flexible Microsoft Excel compatible spreadsheet components and includes SpreadsheetGear 2017 for .NET, 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.

General 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.

Calculation 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. Related Samples

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.

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.

Supported File Formats
XLSX - Open XML Workbook
XLSM - Open XML Macro Enabled Workbook
XLS - Excel 97-2003 Workbook
CSV - Comma Delimited Text
TXT - Tab Delimited Text

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. Related Samples

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.

Charting Features
The most comprehensive Excel compatible charting support available in a Microsoft .NET Framework component. Related Samples
GDI+ and XAML imaging classes provide the ability to generate an image (such as GIF or PNG) with one line of code. Related Samples
Chart rendering supports the most common charting features:
Chart types include area, bar, column, line, pie, stock, XY scatter, radar and bubble charts.
Column Chart Line Chart Pie Chart Bar Chart Area Chart XY Scatter Chart Bubble Chart Radar Chart
Chart type options include multiple chart groups (combination charts), stacked and 100% stacked values, bar gap and overlap, line markers, drop lines, high-low lines, trendlines, series line smoothing, open-close bars, error bars, exploded pies, and data point labels.
Axes options include axes titles, primary and secondary axes sets, auto and manual scaling, logarithmic and date scales, major and minor gridlines and tick marks, reversed axes, tick label positions and rotated text.
General chart options include chart titles, legends, theme colors, auto colors, gradients including Excel compatible preset gradients, solid and dashed line styles, number formats and fonts.

Only for V.I.P
Warning! You are not allowed to view this text.