SpreadsheetGear - performance spreadsheet components
| | | |
Products
Samples
Downloads
Support
Company
Windows Forms Spreadsheet Control Samples
Add powerful spreadsheets to your Windows Forms Applications
Click for a large image of the SpreadsheetGear 2009 WorkbookView control in the Visual Studio 2008 Windows Forms Designer Make life easier for your users with the SpreadsheetGear 2009 Windows Forms spreadsheet controls which combine Visual Studio integration with rich functionality including familiar keyboard and mouse selections, in-cell editing, a FormulaBar control, go to, find, replace, cut, copy, paste, clear, undo, redo, charts, pictures, cell comments, data validation, conditional formats, grouping & outlining, stable sort, text objects, form controls, autoshapes, interruptible background calculation, printing, real-time workbook updates, multiple workbooks, Display Reference, Workbook Designer, Workbook Explorer, Range Explorer, Chart Explorer, Shape Explorer and much more.
SpreadsheetGear Explorer Sample Solutions
Click for a large image of the SpreadsheetGear Explorer C# Sample Solution
SpreadsheetGear 2009 comes with the SpreadsheetGear Explorer Sample Solutions for C# and Visual Basic.

These samples are composed of a set of user controls, each of which demonstrates commonly used SpreadsheetGear 2009 functionality and API's. Source code can be viewed and copied directly from the source viewer below each sample.

Follow these steps to run the SpreadsheetGear Explorer Solution:
  • Install SpreadsheetGear 2009.
  • To open the SpreadsheetGear Explorer Sample solution in Visual Studio, open the Windows Start menu, click on All Programs, click on SpreadsheetGear 2009 and click on SpreadsheetGear Explorer C# Sample or SpreadsheetGear Explorer VB Sample.
  • If you are opening the solution in Visual Studio 2008 for the first time, follow the steps in the Visual Studio Conversion Wizard to convert the solution to Visual Studio 2008.
  • For the best performance, make sure that the current configuration is set to Release rather than Debug.
  • Open the Build menu and choose Rebuild Solution.
  • Open the Debug menu and choose Start Without Debugging to run SpreadsheetGear Explorer.
  • In SpreadsheetGear Explorer, choose among the various samples on the left. Note that many of the samples require user input, such as clicking on a Run Sample button or entering the specified text or number into a cell.
  • Source code can be viewed and copied directly at runtime from the source viewer below each sample.
  • It is important to note that the SpreadsheetGear Explorer samples demonstrate the usage of GetLock and ReleaseLock which are required when using the WorkbookView control with background calculation enabled. ASP.NET developers will almost never use GetLock and ReleaseLock, and at the time of this writing none of the ASP.NET samples provided by SpreadsheetGear LLC use GetLock and ReleaseLock.
Download FREE SpreadsheetGear 2009 Evaluation
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
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
My Boss Thinks
I'm a Genius
"Just wanted to give you a little good feedback on your product. I'm a programmer for a small company in Norway and we needed to create an Excel report for one of our customers. So I purchased a license for your wonderful product and it took me about 10 minutes to get the report from a DataTable into a finished Excel document!

My boss thinks I'm a genius, but hey; the credit should go to your product. At least half of it.

Cheers!"

Hans Olav Stjernholm
Chief Developer
ZapDance as, Norway
SpreadsheetGear Kills
The Competition
"I must say that in terms of structure and completeness, SpreadsheetGear kills the competition."

Mark Keogh, Technical Lead
BCC AdSystems
Sydney, Australia
Fantastically Powerful
Very Easy To Use
"SpreadsheetGear for .NET is a fantastically powerful spreadsheet component which is very easy to use and expand. We delivered our mandatory customer requirements well before time so we had plenty of time to implement the nice-to-have requirements nobody ever manages to deliver."

Simon Black
Software Architect
Nokia
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.