SpreadsheetGear Features
The SpreadsheetGear family of products is made up of powerful and flexible Microsoft Excel compatible spreadsheet components and includes SpreadsheetGear 2023 for .NET Framework, SpreadsheetGear Engine for .NET and SpreadsheetGear for Windows.

SpreadsheetGear enables ASP.NET, ASP.NET Core, Windows Forms, WPF, iOS, Android, Linux, macOS and UWP 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 8.1, Windows 10, Windows Server 2012 (including R2), Windows Server 2016, Windows Server 2019 and Windows Server 2022.
» 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. 
» Powerful Windows Forms and WPF spreadsheet controls. 
» Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel in many cases). 
» Easily create images from Excel charts and ranges. 
» Comprehensive Excel compatible charting. 
» 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.  
» 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. 
» Fast single variable and single target goal seeking. 
» Data validation including operators, alert messages, alert styles, custom formulas and drop-down lists. 
» Conditional formats with support for simple comparison operators and custom formulas. 
» Copy and insert DataTables into pre-formatted ranges with complete formula, border and format fixups. 
» Easily convert entire workbooks or specific ranges to a DataSet or DataTable.
» 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. 
» Grouping and outlining of rows and columns. 
» Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
» Copy, insert and move entire worksheets. 
» Reads and writes VBA Macros (preservation only--does not include execution of Macros).
» A wide variety of C# samples including live samples for ASP.NET Core Razor Pages and Windows Forms. 

 Calculation Engine

» Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel in many cases). 
» Multi-threaded calculations efficiently utilize today's 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). Samples
» 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. 
» Built-In Document Properties and Custom Document Properties. 
» Custom functions, minimal recalc, iteration, precision as displayed and more. 
» 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. Samples
» Workbook and worksheet scoped named ranges. Samples
» Built-In Document Properties and Custom Document Properties. 
» Options to show and hide worksheet tabs and scrollbars. 
» Helper methods to convert Excel Serial Dates and Times to .NET DateTime objects and back. Samples

 Worksheet Features

» AutoFilters 
         » 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 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. 
» GoalSeek - Fast single variable and single target goal seeking. Samples
» Cell Data Validation - including operators, alert messages, alert styles, custom formulas and drop-down lists. 
» Conditional Formatting
         » 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 
» 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. 
» 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. 
» Page Setup Options
         » Print area, title rows / title columns and orientation. 
         » Margins, page order, page zoom and fit to pages. 
         » Custom headers and footers included embedded pictures. 
» Print preview.
» Print to XPS files.

 Charting Features

» The most comprehensive Excel compatible charting support available in a Microsoft .NET Framework component. 
» GDI+ and XAML imaging classes provide the ability to generate an image (such as GIF or PNG) with one line of code. 
» Chart rendering supports the most common charting features:
         » Chart types include area, bar, column, line, pie, stock, XY scatter, radar and bubble charts.
         »  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.

 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. 
» Fonts, borders, cell interior color and gradient fills, Office theme colors with tinting and shading, RGB colors, Excel palette indexed colors and patterns. 
» Horizontal alignment, vertical alignment, word wrap and rotated text. 
» Merged cells, hyperlinks and conditional formats. 
» Grouping and outlining of rows and columns. 
» Automatic row heights and column widths.
» Copy formats without affecting formulas or values.
» Named cell style support. 

 Spreadsheet Control Features

» SpreadsheetGear Explorer Sample Solutions for Windows provide source code which demonstrates commonly used features and APIs. 
» Windows Forms and WPF 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 2012, Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, Visual Studio 2019 and Visual Studio 2022 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, Visual Studio 2017 and Visual Studio 2019 including the ability to use the WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer » and ShapeExplorer at design time and at runtime.

 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

 Microsoft .NET 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 NET 3.5 .NET 4.0, .NET 4.5.x, .NET 4.6.x, .NET 4.7.x, .NET 4.8, as well as .NET 6 and any platform that supports .NET Standard 2.0.
» Supports 32- and 64- bit versions of Windows 8.1, Windows 10, Windows Server 2012 (including R2), Windows Server 2016, Windows Server 2019 and Windows Server 2022.
» Visual Studio 2012, Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, Visual Studio 2019 and Visual Studio 2022 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.

 SpreadsheetGear Engine for .NET 
A broad cross-platform library that provides a programmatic, in-code spreadsheet feature set similar to that offered by SpreadsheetGear for .NET Framework.

• Formerly known as "SpreadsheetGear for .NET Standard".
• Includes a .NET Standard 2.0 target to support various platforms such as .NET Framework 4.6.2 or higher, .NET 6 (works with earlier versions), UWP, Xamarin, Mono and more.
• Includes a .NET 6 target, which provides all the capabilities of the .NET Standard 2.0 target plus utilization of "hardware intrinsics" which enable additional optimizations on specific hardware when supported on the hosting machine.
• UI capabilities are not included in this product (see SpreadsheetGear for Windows).
• Go to NuGet Package page.

 SpreadsheetGear for Windows 
Builds on top of the SpreadsheetGear Engine for .NET product to provide various Windows-based UI capabilities.

• A SpreadsheetGear for Windows license includes access to SpreadsheetGear Engine for .NET.
• Interactive WorkbookView and FormulaBar controls Windows Forms and WPF applications, with high-DPI support.
• WorkbookDesigner dialog and "Explorer" dialogs to modify various aspects of a workbook such as worksheets, ranges, charts, shapes, etc.
• Image rendering of ranges, charts and other shapes.
• Printing capabilities.
• Go to NuGet Package page.

 SpreadsheetGear for .NET Framework 
Trusted by thousands of companies for over 18 years and 9 major version releases, SpreadsheetGear for .NET Framework is the ultimate solution for all things spreadsheets on .NET Framework.

• Extensive APIs to read, write and modify workbooks, charts and more.
• Blazingly fast multi-threaded calculation engine with support for 449 functions.
• Interactive WorkbookView and FormulaBar controls for Windows Forms and WPF applications.
• WorkbookDesigner dialog and "Explorer" dialogs to modify various aspects of a workbook such as worksheets, ranges, charts, shapes, etc.
• High-DPI image rendering of ranges, charts and other shapes.
• Printing capabilities.

 SpreadsheetGear Bundle 
The SpreadsheetGear Bundle gains you access to the entire suite of SpreadsheetGear products.

• SpreadsheetGear Engine for .NET
• SpreadsheetGear for Windows
• SpreadsheetGear for .NET Framework

▲ *  V* 詳情請詢問友環業務

Supported Excel-Compatible Functions  
449 of Excel's financial, date, time, text, lookup, math, trigonometry, statistical, engineering, database, information, logical and web functions.

 詳細比較表 請點擊此觀看 

SpreadsheetGear Engine for .NET
Targets .NET Standard 2.0 and .NET 6
Formerly "SpreadsheetGear for .NET Standard"

SpreadsheetGear for Windows
Targets .NET 6 for Windows
All the power of "SpreadsheetGear for .NET Framework" in .NET 6 for Windows

SpreadsheetGear 2023 for .NET Framework (9.2.59.102)
Requires Microsoft .NET Framework 3.5+.
WPF controls and multithreaded recalc require.NET Framework 4.6.2 or later.

 Current Hotfixes  SpreadsheetGear 2023 for .NET Framework (9.3.3.102)
Requires Microsoft .NET Framework 3.5+.
WPF controls and multithreaded recalc require.NET Framework 4.6.2 or later.
Prior Versions