Description

SpreadsheetGear Engine for .NET 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 4.6.2+, ASP.NET Core, Universal Windows Platform (UWP), Xamarin.iOS, Xamarin.Android, Xamarin.Forms, Mono and any other platform which supports .NET 6 or .NET Standard 2.0.

General Features

Royalty free deployment to 32-bit and 64-bit Windows 8.1, Windows 10, Windows 11, 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# including live 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).

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.

Workbook and worksheet scoped named ranges.

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.

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.

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.

Additional Information