SpreadsheetGear - performance spreadsheet components
| | | |
Products
Samples
Downloads
Support
Company
Excel Calculation Engine Samples
Fastest and most complete Excel compatible calculations without Excel
Excel Calculation Samples The true power of SpreadsheetGear 2010 is realized when using its superior Microsoft Excel compatible calculation engine. Its unmatched performance and accuracy provide a competitive advantage to data critical Windows Forms and ASP.NET applications. The following samples show various ways to utilize the spreadsheet calculation engine to manipulate data in an ASP.NET project. These examples are easily adapted to many Microsoft .NET Framework solutions.
  
Formula Evaluation
This sample demonstrates evaluating a single Excel compatible formula entered into a web form.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Simple Loan Calculator
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.
[Run Sample] | [C# Source] | [VB.NET Source] | [View XLS]
  
Amortization Calculator
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.
[Run Sample] | [C# Source] | [VB.NET Source] | [View XLS]
  
Custom Functions
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.
[Run Sample] | [C# Source] | [VB.NET Source]
SpreadsheetGear 2010
Now Available
NEW!  Autofilters, password protected workbooks, macro-enabled Open XML (.xlsm) support, Excel 2010 support, Visual Studio 2010 and .NET 4.0 support, a number of charting features and more.

Download the FREE Trial.
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
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."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC
Performance, Flexibility
Priceless Support
"We started to use SpreadsheetGear for .NET almost two years ago when the performance of other controls was becoming problematic. We needed a control that could handle large workbooks with complex formulas to be able to apply Monte Carlo simulation to financial statements. Since that time SpreadsheetGear for .NET has become our tool of choice not only for the performance but also for the flexibility. But most of all, the technical support we receive from SpreadsheetGear LLC is priceless; it has always been fast and accurate with the vision to arrive at the desired solution."

Frédérick Faucher
Analyste Financier
Solutions Modex Inc.
Montréal, Canada
SpreadsheetGear for .NET
Robust & Comprehensive
We really love SpreadsheetGear for .NET. The comprehensive and robust set of worksheet functions ensures that our customers are able to fully leverage their Excel knowledge in our product.

Andreas Lipphardt
XLCubed Ltd
Hessen Germany
The Best Tutorial I
Have Ever Encountered
“Your SpreadsheetGear Explorer Sample Solution may be the best tutorial I have ever encountered. In a matter of minutes, I believe I fully understand the major elements and some of the subtle nuances of code needed to put an Excel compatible chart on a Windows Form. In every way I have used SpreadsheetGear, I have been delighted with the documentation, content, performance, and support."

David W. Smith
Materials Engineer
Rolls-Royce Corporation
Every Day that Goes By
I Am More Amazed
I must say that everyday that goes by I am more amazed with your component. It’s easy to use but still powerful. No more problems using Excel workbooks in the .NET environment.

You have spared me about 3 or 4 months of work with your excellent tool. I also must say that I’m using many other components from other companies and no one has proven to be as fast and effective as you in solving a support request.

Pedro Horta
IT Analyst / Programmer
OmnicomMediaGroup
Portugal
ASP.NET and
SpreadsheetGear
A Match Made in Heaven
"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."

Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer
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
SpreadsheetGear for .NET Worked as Described
"After trying every Microsoft Excel compatible spreadsheet solution for the .NET Framework I could find, SpreadsheetGear for .NET is the only one that actually worked as described."

Michael Garnett
Interpublic Group
New York, NY
Unmatched Speed
and Ease of Coding
Make it a Winner
SpreadsheetGear is a great product. The speed is unmatched and the ease of coding makes it a winner.

Steve Cruickshank
Redwood Software
Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.