SpreadsheetGear 2017 adds a new SpreadsheetGear for .NET Standard product,
official support for Excel 2013, Excel 2016, Excel 2019 (V8.2) and Excel for Office 365 (V8.2), 51 new Excel functions, full
conditional formatting support, enhanced workbook protection and encryption,
cell gradient rendering and
more.
Latest Hotfix Release
Our latest hotfix (8.5.6.102) was released on
Jan 12, 2021. Learn more about this build on the
What's New page or download it from the
Licensed Users Downloads
page.
SpreadsheetGear for .NET Standard
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 Compatible WinForms, WPF and Silverlight Controls
Add powerful viewing, editing,
formatting, calculating, charting and printing capabilities to your
Windows Forms, WPF and Silverlight applications with WorkbookView and
FormulaBar controls. WinForms and WPF applications can also utilize
the Workbook Explorer, Range Explorer, Chart Explorer and Shape Explorer dialogs.
DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP DATE DATEDIF DATEVALUE DAY DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORKDAYS NETWORKDAYS.INTL NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY WORKDAY.INTL YEAR YEARFRAC BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERF.PRECISE ERFC ERFC.PRECISE GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2DEC OCT2HEX ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA TYPE AND FALSE IF IFERROR NOT OR TRUE ADDRESS AREAS CHOOSE COLUMN COLUMNS HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS TRANSPOSE VLOOKUP ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING CEILING.PRECISE COMBIN COS COSH DEGREES EVEN EXP FACT FACTDOUBLE FLOOR FLOOR.PRECISE GCD INT LCM LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SERIESSUM SIGN SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE COVAR EXPONDIST FDIST FINV FTEST GAMMADIST GAMMAINV LOGINV LOGNORMDIST MODE NEGBINOMDIST NORMDIST NORMINV NORMSDIST PERCENTILE PERCENTRANK POISSON QUARTILE RANK STDEV STDEVP TDIST TINV TTEST VAR VARP WEIBULL ZTEST AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETA.DIST BETA.INV BINOM.DIST BINOM.INV CHISQ.DIST CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST CONFIDENCE.NORM CONFIDENCE.T CORREL COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVARIANCE.P COVARIANCE.S CRITBINOM DEVSQ EXPON.DIST F.DIST F.DIST.RT F.INV F.INV.RT F.TEST FISHER FISHERINV FORECAST FREQUENCY GAMMA.DIST GAMMA.INV GAMMALN GAMMALN.PRECISE GEOMEAN GROWTH HARMEAN HYPGEOM.DIST HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGNORM.DIST LOGNORM.INV MAX MAXA MEDIAN MIN MINA MODE.MULT MODE.SNGL NEGBINOM.DIST NORM.DIST NORM.INV NORM.S.DIST NORM.S.INV NORMSINV PEARSON PERCENTILE.EXC PERCENTILE.INC PERCENTRANK.EXC PERCENTRANK.INC PERMUT POISSON.DIST PROB QUARTILE.EXC QUARTILE.INC RANK.AVG RANK.EQ RSQ SKEW SLOPE SMALL STANDARDIZE STDEV.P STDEV.S STDEVA STDEVPA STEYX T.DIST T.DIST.2T T.DIST.RT T.INV T.INV.2T T.TEST TREND TRIMMEAN VAR.P VAR.S VARA VARPA WIEBULL.DIST Z.TEST CHAR CLEAN CODE CONCATENATE DOLLAR EXACT FIND FINDB FIXED LEFT LEFTB LEN LENB LOWER MID MIDB PROPER REPLACE REPLACEB REPT RIGHT RIGHTB SEARCH SEARCHB SUBSTITUTE T TEXT TRIM UPPER USDOLLAR VALUE ACOT ACOTH AGGREGATE ARABIC BASE BINOM.DIST.RANGE BITAND BITLSHIFT BITOR BITRSHIFT BITXOR CEILING.MATH COMBINA COT COTH CSC CSCH DAYS DECIMAL ENCODEURL FILTERXML FLOOR.MATH GAMMA GAUSS IFNA IMCOSH IMCOT IMCSC IMCSCH IMSEC IMSECH IMSINH IMTAN ISFORMULA ISO.CEILING ISOWEEKNUM MUNIT NUMBERVALUE PDURATION PERMUTATIONA PHI RRI SEC SECH SHEET SHEETS SKEW.P UNICHAR UNICODE WEBSERVICE XOR
Excel Calculations
Evaluate complex Excel based models and business rules with the fastest and
most complete Excel compatible calculation engine available with 449 Excel
compatible functions, multithreaded calculations, array formula support and more.
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.
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.
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.
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.
Enable users to visualize data with comprehensive Excel compatible charting which makes
creating, modifying, rendering and interacting with complex charts easier than ever before.
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 2017 adds a new SpreadsheetGear for .NET Standard product, official support for Excel 2019 and Excel for Office 365, 51 new Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering and more.
Microsoft Chooses SpreadsheetGear for .NET
"After carefully evaluating SpreadsheetGear, Excel Services, and other 3rd party options, we ultimately chose SpreadsheetGear for .NET because it is the best fit for MSN Money."
Chris Donohue Program Manager MSN Money
Reduced Time From 20 Minutes to 4 Seconds
"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"
Luke Melia, Software Development Manager Oxygen Media, New York
Over 100 Times Faster Than Other Controls
"We just wanted you to know how thrilled we are by the performance we are seeing with SpreadsheetGear for .NET. A 6,000 KB Excel workbook is loading into the WorkbookView control in less than a second. This is over 100 times faster than other controls we’ve tested. That difference makes it possible for us to develop and release a viable product with the Microsoft .NET Framework."
Amy Tate Chief .NET Architect Applied OLAP, Inc. Huntsville, Alabama
Spreadsheet Component Industry Veterans
"Our key developers have over fifty years of combined experience developing high performance commercially available spreadsheet technology which is used by most of the Fortune 500."
"SpreadsheetGear for .NET is truly a pleasure to work with. I was up and running within the first day. It is the best spreadsheet generator out on the market. Performance, Ease of Use, and Full Control of the generation process sold me. I no longer have to be concerned with memory leaks, hung processes, COM Interop and slow performance. Our users demand cosmetically appealing reports without additional work. I can build templates at will, with complete control to freeze panes, page setup, cell formats, etc., etc. The old days of pre-building templates are gone. I cannot think of anything this product cannot do."
Todd Dickard TA Billing Systems Mgr. TravelCenters of America
I conducted a three month analysis comparing three top spreadsheet controls for .NET application developers: SpreadsheetGear, SyncFusion XlsIO, and ComponentOne Spread.NET. The definite winner was SpreadsheetGear, with ComponentOne Spread.NET in second. SpreadsheetGear provides the most Excel-like experience, is the most performant, and provides the most responsive and capable product support.
I build a reporting engine for my company and SpreadsheetGear made it awesome. Our customers have been very pleased. I wanted to share my extensive analysis with any other developers out there trying to find the right spreadsheet control for their .NET application.
Joseph Fluckiger Sr. Software Architect Thermo Fisher Scientific Austin, TX
SpreadsheetGear Samples and Tutorials
SpreadsheetGear and ASP.NET make it easy to automate Excel report generation, create dynamic dashboards from Excel charts and ranges, utilize high performance Excel compatible calculations without Excel, and move data between Excel workbooks and DataSets, DataTables, and DataGrids.
Tutorials demonstrate SpreadsheetGear for .NET Standard in ASP.NET Core MVC, .NET Core, Xamarin.iOS and Xamarin.Android. SpreadsheetGear for .NET Standard could also be used on other platforms such as the full .NET Framework, Universal Windows Platform (UWP), Xamarin.Forms, Mono and any other platform that supports .NET Standard 1.3.
Make life easier for your users with the SpreadsheetGear Windows Forms and WPF spreadsheet controls which combine Visual Studio integration with the ability to create, read, modify, view, edit, format, calculate, sort, filter, print and write Microsoft Excel 97-2019 and Excel for Office 365 workbooks without Excel.
Take your browser based applications beyond the limits of HTML and JavaScript with SpreadsheetGear for Silverlight which is built on the same Excel compatible spreadsheet and charting engines as SpreadsheetGear for .NET.
Have an up-to-date and valid License Number? Download the latest Licensed versions of SpreadsheetGear Now! If you need a License, go to our Purchase Page to purchase one today.
The 30-Day Evaluation versions of SpreadsheetGear are good representations of the fully licensed products. Beyond the presence of multiple timeout mechanisms, the only other limitation placed in these builds is the addition of watermarks over images rendered with the Image API.