SpreadsheetGear - performance spreadsheet components
Home | Contact | Site Map | Download | Purchase
Products
SpreadsheetGear 2010
Purchase SpreadsheetGear
Samples
ASP.NET Samples
Windows Forms Samples
Downloads
Licensed Users Downloads
Download 30-Day Evaluation
Support
FAQ
How To
Documentation
Submit Issues
Company
Home Page
About Us
Contact
Resellers
Privacy
News
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]
Like SpreadsheetGear?
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
Fantastic -- From Excel
To ASP.NET Dashboard
in a Single Afternoon
"Fantastic evaluation -- I started with a customer’s Excel workbook with a dashboard containing variable cells and a chart. Using SpreadsheetGear, and your Dashboard from 1693 Analytics sample as a template, I created my own ASP.NET page to display our client’s dashboard, and update based on the selection of parameters which get plugged into the variable cells. And I got this working in a single afternoon."

Andy Hofer
Directory of Development
NST Systems, Inc.
Stamford, CT
Creating Excel Reports
Has Never Been Easier
"I really am happy with SpreadsheetGear for .NET. It works fantastic, very smooth to handle. Creating Excel Reports has never been easier for me!"

Wolfgang Kamir
Softwaretailor
Baden, Lower Austria
I'm Impressed With the
Ease of Use and Speed
"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"

José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina
SpreadsheetGear for .NET
A Pleasure to Work With
"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
Best Component Purchase
for Many Years
“SpreadsheetGear for .NET provides a platform for spreadsheet web extension second to none. We were able to implement our custom formulas using the SpreadsheetGear engine with ease and these interact with the Excel functions seamlessly. The performance is superb and in many cases faster than in Excel which has been a pleasant surprise. The expertise of the development team is very apparent and we look forward to the new product enhancements coming down the line. From a return on investment perspective this has been our best component purchase for many years."

Mark Scanlon
Managing Director
XLCubed Ltd
Excellent Product
And Service
"Thank you for all your help during the trial period.

Your excellent product and service is what convinced us to buy this component."

Etienne Demers
OceanLogics, Canada
Wow!
Perfect!!!
"Wow! Thank you for the hint!

Your support is like your product: Perfect!!!"

Christian Donges
:em engineering methods AG
Darmstadt, Germany
Copyright © 2003-2011 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.