SpreadsheetGear - performance spreadsheet components
| | | |
Products
Downloads
Support
Company
Frequently Asked Questions

1. Can SpreadsheetGear for .NET be deployed royalty free?
2. How many developer licenses do I need to purchase?
3. Is Excel required to use SpreadsheetGear for .NET?
4. Is COM required to use SpreadsheetGear for .NET?
5. Does SpreadsheetGear for .NET support Excel 2007?
6. Does SpreadsheetGear for .NET support charts?
7. Do you have a list of supported Excel functions?
8. Do you have samples for Windows Forms Applications?
9. How do I use SpreadsheetGear for .NET in a Visual Studio 2005 / 2008 or Visual Web Developer Express Edition Web Site Project?
10. How do I add the SpreadsheetGear for .NET Windows Forms Controls to the Microsoft Visual C# 2005 / 2008 Express Edition Toolbox or the Microsoft Visual Basic 2005 / 2008 Express Edition Toolbox?
11. Can multiple versions of SpreadsheetGear for .NET be used at the same time on one machine?
12. Why don't I see SpreadsheetGear listed under the .NET tab when using Add Reference?
13. Why does the IntelliSense and Dynamic Help not work in Visual Studio?


  
Can SpreadsheetGear for .NET be deployed royalty free?
SpreadsheetGear for .NET can be deployed royalty free with most client and server applications. Please see the license agreement for limitations.
  
How many developer licenses do I need to purchase?
One developer license is required for each and every developer working on any application which utilizes SpreadsheetGear.dll.
  
Is Excel required to use SpreadsheetGear for .NET?
No, Excel is not required to use SpreadsheetGear for .NET. Using Excel in a server environment is not supported, which makes SpreadsheetGear for .NET a good solution for your server applications as well as your client applications.
  
Is COM required to use SpreadsheetGear for .NET?
No, SpreadsheetGear for .NET is 100 percent safe managed code written exclusively for the .NET Framework. All that is required is the .NET Framework and SpreadsheetGear.dll.
  
Does SpreadsheetGear for .NET support Excel 2007?
SpreadsheetGear for .NET does not support the Excel 2007 (XLSX) file format. Excel 2007 can read and write Excel 97-2003 (XLS) workbooks which are compatible with SpreadsheetGear for .NET.

We are adding robust support for the Excel 2007 (XLSX) file format in SpreadsheetGear for .NET 2008 which we intend to release in the summer of 2008. Every subscription purchased now will include SpreadsheetGear for .NET 2008.
  
Does SpreadsheetGear for .NET support charts?
SpreadsheetGear for .NET supports reading and writing charts as well as pictures, text and other drawing objects. Series data sources, gradients, fonts, number formats, etc... are maintained. See the Excel Charting Samples for live examples and source code.

We are adding chart rendering, editing and APIs in SpreadsheetGear for .NET 2008 which we intend to release in the summer of 2008. Every subscription purchased now will include SpreadsheetGear for .NET 2008.
  
Do you have a list of supported Excel functions?
See the Supported Excel Functions on the product page.
  
Do you have samples for Windows Forms Applications?
SpreadsheetGear for .NET 2007 comes with the SpreadsheetGear Explorer, a helpful Windows Forms Application sample soluton for Visual Studio 2005 and Visual Studio 2008. See Windows Forms Spreadsheet Control Samples for instructions on running the SpreadsheetGear Explorer.
  
How do I use SpreadsheetGear for .NET in a Visual Studio 2005 / 2008 or Visual Web Developer Express Edition Web Site Project?
Follow these getting started instructions and then refer to the live ASP.NET Samples.
  
How do I add the SpreadsheetGear for .NET Windows Forms Controls to the Microsoft Visual C# 2005 / 2008 Express Edition Toolbox or the Microsoft Visual Basic 2005 / 2008 Express Edition Toolbox?
1. Install Microsoft Visual C# 2005 / 2008 Express Edition or Microsoft Visual Basic 2005 / 2008 Express Edition.
2. Install SpreadsheetGear for .NET.
3. Launch Visual C# Express or Visual Basic Express.
4. On the File menu click New Project…. The New Project dialog box appears. (You may also Open an existing Windows Application project.)
5. Under Templates, choose Windows Application.
6. Change the Name as desired.
7. Click OK to create the project
8. On the View menu click Toolbox. The Toolbox appears.
9. Right-click in the Toolbox and click Add Tab. A new Tab appears to be named.
10. Name the Tab (such as SpreadsheetGear)
11. Right-click within the Tab and click Choose Items….
12. Scroll through the list and check FormulaBar and WorkbookView.
13. Click OK to add the controls to the Tab.
  
Can multiple versions of SpreadsheetGear for .NET be used at the same time on one machine?
Yes. SpreadsheetGear for .NET is a strong named assembly which enables the installation and use of multiple versions on one machine.
  
Why don't I see SpreadsheetGear listed under the .NET tab when using Add Reference?
Visual Studio only looks for new .NET components once. Be sure to close and restart Visual Studio after installing SpreadsheetGear for .NET.
  
Why does the IntelliSense and Dynamic Help not work in Visual Studio?
If you recently installed a new version of SpreadsheetGear, you may need to remove the reference to the SpreadsheetGear assembly from your project using the Solution Explorer window in Visual Studio. First, remove the old reference, then, add the new one back by using the .NET tab of the Add Reference dialog.

Note: It may be necessary to delete any occurences of SpreadsheetGear.dll from your project directory before adding the new assembly.
SpreadsheetGear for .NET
2007 V3.1 Now Available
See What's New and
download the Licensed or
Evaluation version Now.
Spreadsheet Component
Industry Veterans
"For more than twenty years, we have been creating and leading the development of high performance 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
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
SpreadsheetGear Joins
Microsoft VSIP Program
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.

Microsoft VSIP Program
Hands Down the Most
Intuitive and Easy to Use
"Thanks again for your prompt response, and I would just like to say that this is by far the best library that I have worked with. It is hands down the most intuitive and easy to use API that I have used to work with Excel files. Its performance is hard to beat as well.”



Levi Wilson
Software Developer
Press Ganey Associates
South Bend, Indiana
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
Creating Excel Reports
Has Never Been Easier
"I really am happy with SpreadsheetGear for .NET. It works fantastic, very smooth to handle. Creating Excel Reports has never been easier for me!"

Wolfgang Kamir
Softwaretailor
Baden, Lower Austria
By Far the Best Library
That I Have Worked With
"Thanks again for your prompt response, and I would just like to say that this is by far the best library that I have worked with. It is hands down the most intuitive and easy to use API that I have used to work with Excel files. Its performance is hard to beat as well.”



Levi Wilson
Software Developer
Press Ganey Associates
South Bend, Indiana
Reduced Time From
20 Minutes to 4 Seconds
"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"

Luke Melia, Software
Development Manager
Oxygen Media, New York
SpreadsheetGear for .NET
Robust & Comprehensive
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
Copyright © 2003-2008 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks 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.