Visit Our Facebook Page
Visit Our Google Plus Page
Visit Our Twitter Page
What's New
ASP.NET, Windows Forms and Silverlight SpreadsheetGear Samples
Purchase SpreadsheetGear
Download SpreadsheetGear

Excel Calculation Engine Samples

Fastest and most complete Excel compatible calculations without Excel

Excel Calculation Samples

The true power of SpreadsheetGear 2012 is realized when using its superior Microsoft Excel compatible calculation engine. Unmatched performance and accuracy, 398 Excel compatible functions, multithreaded recalc, array formula support and more provide a competitive advantage to any ASP.NET, Windows Forms, WPF or Silverlight application.


This sample demonstrates evaluating a single Excel compatible formula entered into a web form.

This sample demonstrates calculating a loan payment based on input from a web form. By using this design pattern, you can easily deploy complex numeric, financial and statistics calculators which call on the full power of SpreadsheetGear 2010's Microsoft Excel compatible calculation capabilities.

This sample extends the Simple Loan Calculator with an amortization table which is displayed in an ASP.NET DataGrid control. Of particular interest is the use of the defined name, AmortizationTableForNPer, which uses the OFFSET() worksheet function to return a dynamically sized range.

This sample demonstrates creating your own custom functions in the Microsoft .NET Framework and adding them to a workbook set. The worksheet formulas which utilize these custom functions are compatible with Microsoft Excel worksheet formulas which utilize VBA or XLL custom functions.