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, enhanced printing support, 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
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
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
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
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
SpreadsheetGear
ROCKS!!!!
"We recently bought SpreadsheetGear for an Excel reporting project and have found it to be excellent!

However, this week I have discovered that I can use SpreadsheetGear to open an Excel spreadsheet and interrogate it on the fly. This facility has literally saved me weeks of work. Hence I am just dropping you a quick email to say thank you very much.

SpreadsheetGear ROCKS!!!!"

Andrew Breward
Caboodal
SpreadsheetGear 2009
In a League by Itself
"SpreadsheetGear 2009 is Fantastic! I hate to think of NOT having SpreadsheetGear for even one day. These new capabilities just propelled this control way-way past any competition, of which you have none IMHO.

As a programmer, I respect the amount of work, etc., that goes into a product that works well and as advertised. We have been using SpreadsheetGear since 2006 and it has saved us countless hours, headaches and $$$. We have had no recurring crashes since we removed all Office COM objects and replaced them with SpreadsheetGear. It seems that everything runs a lot smoother and much faster.

SpreadsheetGear is in a league all by itself."

Greg Newman
Senior Software Engineer
WSFS Cash Connect
Natural API,
Blindingly Fast, Wow!
“Your interface-based approach is refreshing: the API is natural and the underlying code is blindingly fast for what it does.

Changing my Excel abstraction to use SpreadsheetGear brought a 2 month pull from 48 minutes (2880 seconds) to 12.7 seconds.

Wow!"

Dennis C. Wright
dWare.biz, LLC
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.