SpreadsheetGear - performance spreadsheet components
| | | |
Products
Downloads
Support
Company
Excel to DataGrid Samples
Quickly populate DataGrids from Excel workbooks without Excel
DataGrid Samples Microsoft Excel workbooks are an excellent source of data for the built-in DataGrid, DataSet and DataTable components included in the Microsoft .NET Framework, as well as the many third party charting and other controls which accept a DataSet or DataTable. SpreadsheetGear for .NET makes it easy to populate a DataSet or DataTable from a workbook or worksheet range, as demonstrated by these samples.
  
Excel to DataGrid
This sample shows how to retrieve data from a Microsoft Excel workbook and display it in an ASP.NET DataGrid control.
[Run Sample] | [C# Source] | [VB.NET Source] | [XLS]
  
Excel to Multiple DataGrids
This sample shows how to retrieve data from multiple worksheets in a Microsoft Excel workbook and display it in multiple ASP.NET DataGrid controls.
[Run Sample] | [C# Source] | [VB.NET Source] | [XLS]
  
DataTable to Excel Workbook with Formats and Formulas
This sample shows how to insert data from a DataTable into an Excel workbook, merging the data with formatting and formulas. The results are displayed in an ASP.NET DataGrid control.
[Run Sample] | [C# Source] | [VB.NET Source] | [Template] | [XML]
  
Excel Workbook Consolidation
This sample shows how to utilize the IRange.Copy method to dynamically copy and consolidate data from multiple workbooks.
[Run Sample] | [C# Source] | [VB.NET Source]
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
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
First Rate Support
Superior Control
"Your support is first rate. We always get an answer within a few minutes of any request or question. This support, combined with the exceptional speed and ease of use of your superior control enables me to create complex spreadsheet solutions that work in a few minutes instead of days. Keep up the excellent work!"

Greg Newman
WSFS Bank
Newark DE
The Daily Grind Reviews SpreadsheetGear for .NET
September 22, 2005 - "The license allows royalty free deployment, making this a cost effective alternative to Excel as well as a technically superior one for generating worksheets and performing heavy-duty calculations from your .NET applications."

Mike Gunderloy
Lead developer for Larkware
Author of numerous books and articles on programming.
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
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
Your Quick Responses...
You Continue to Impress
"Your quick responses to queries are one of the original reasons why we opted for your product, and you continue to impress us with the speed at which questions and issues are dealt with."

Justin Blackwell
Volume Design Ltd.
Berkshire, United Kingdom
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.