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 2009 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 2009'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 2009
Now Available
NEW!  93 Analysis Toolpak functions, CSV and text files, auto fill, goal seeking, data series, bubble charts, chart axis titles, gradients, rotated text and more.  Download the Licensed version or the FREE Evaluation Now.
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 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
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
Your Quick Responses...
You Continue to Impress
"Your quick responses to queries are one of the original reasons why we opted for your product, and you continue to impress us with the speed at which questions and issues are dealt with."

Justin Blackwell
Volume Design Ltd.
Berkshire, United Kingdom
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
Great Piece of Software
Solves Real Problems
"SpreadsheetGear for .NET is a great piece of software that has given me faith that there are still developers who write great code to solve real problems and are serious about supporting it."

Deane Barker
Blend Interactive
Sioux Falls, South Dakota
Vision and Ability for Advanced Spreadsheets
September 20, 2005 - "With SpreadsheetGear, we finally have a company that understands our requirements in regards to supporting the Microsoft Excel file format in the Microsoft .NET Framework. SpreadsheetGear has the vision and the ability to provide the advanced spreadsheet functionality our customers expect in our products."

Tim Tow
President
Applied OLAP, Inc.
Former Microsoft Excel MVP
Above and Beyond Support, Exceptional
"Although there was an initial issue related to date formatting associated with a cultural problem, I found that SpreadsheetGear provided myself, and ultimately the bank, with above and beyond support, providing us with the necessary fix for the issue within 2 days.  This is nothing less than exceptional, and I for one would like to thank SpreadsheetGear for their tenacity, enthusiasm and dedication to their product."

David Lashley
IT Development Manager
Commercial Bank of Qatar
Copyright © 2003-2009 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.