SpreadsheetGear 2008 comes with the SpreadsheetGear Explorer sample solutions which are helpful Windows Forms applications for Visual Studio 2005. Visual Studio 2008 will offer to convert these solutions to Visual Studio 2008 solutions the first time they are opened.
The SpreadsheetGear Explorers are available in C# and Visual Basic and are composed of a set of user controls, each of which demonstrates commonly used SpreadsheetGear 2008 functionality and API's. Source code can be viewed and copied directly from the source viewer below each sample. Follow these steps to open and run the SpreadsheetGear Explorer solutions from Windows (requires a version of Visual Studio 2005 or Visual Studio 2008 which supports Windows Forms solutions and either C# or Visual Basic):
- Install SpreadsheetGear 2008.
- To open the SpreadsheetGear Explorer Sample solution in Visual Studio, open the Windows Start menu, click on All Programs, click on SpreadsheetGear 2008 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.