|
Add powerful spreadsheets to your Windows Forms Applications |
|
|
 |
Make life easier for your users with the SpreadsheetGear 2010 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, autofilters, 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 |
|
SpreadsheetGear 2010 comes with the SpreadsheetGear Explorer Sample Solutions for C# and Visual Basic.
|
 |
David W. Smith of Rolls-Royce said " Your SpreadsheetGear Explorer Sample Solution may be the best tutorial I have ever encountered."
These samples are composed of a set of user
controls, each of which demonstrates commonly used SpreadsheetGear 2010 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 2010.
- To open the SpreadsheetGear Explorer Sample solution in Visual Studio, open the Windows Start menu, click on All Programs, click on SpreadsheetGear 2010 and click on SpreadsheetGear Explorer C# Sample or SpreadsheetGear Explorer VB Sample.
- If you are opening the solution in Visual Studio 2008 or Visual Studio 2010 for the first time, follow the steps in the Visual Studio Conversion Wizard to convert the solution to Visual Studio 2008 or Visual Studio 2010.
- 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 from 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.
- If you have trouble using the SpreadsheetGear Explorer Samples, please refer to Troubleshooting SpreadsheetGear Explorer in the SpreadsheetGear Help under Getting Started -> Using the Samples -> SpreadsheetGear Explorer Sample Solutions.
|
|
Download FREE SpreadsheetGear 2010 Evaluation |
|
|
| |
|
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.
|
|
"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 |
|
“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 |
|
“Thank you again for your brilliant product and fanatical support. We have never looked back since we discarded FarPoint’s Spread in favour of SpreadsheetGear."
Earl J. Steyn
Data Prime Solutions
Johannesburg, South Africa |
|
"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 |
|
"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 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 |
|
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 |
|
August 23, 2005 - "We welcome SpreadsheetGear to the Microsoft Visual Studio Industry Partner Program. The improved ability to create, modify, calculate, read and write Microsoft Excel (versions 97 and higher) workbooks will allow our mutual customers to create a broad range of solutions in a rich and familiar form."
Nick Abbott
Group Manager
.NET Developer Product Marketing Group
Microsoft Corp.
|
|
“SpreadsheetGear helped our team of developers in developing a .NET library that allows users to create custom reports. The ease of use of the SpreadsheetGear product saved us hours of development time and ultimately helped deliver an excellent product to the client. We would definitely recommend using this product!
Robert Jumblatt
Principal
CoreBix LLC
Vienna, VA |
|
