SpreadsheetGear - performance spreadsheet components
Home | Contact | Site Map | Download | Purchase
Products
SpreadsheetGear 2010
Purchase SpreadsheetGear
Samples
ASP.NET Samples
Windows Forms Samples
Downloads
Licensed Users Downloads
Download 30-Day Evaluation
Support
FAQ
How To
Documentation
Submit Issues
Company
Home Page
About Us
Contact
Resellers
Privacy
News
Excel to DataGrid Samples
Quickly move data from DataGrids to Excel and back without Excel
DataGrid Samples DataGrids, DataSets and DataTables are a staple of many Microsoft .NET Framework applications. SpreadsheetGear 2010 makes it easy to copy data from workbooks and ranges of cells to DataGrids, DataSets and DataTables. Copying the DataGrids, DataSets and DataTables back to a workbook or range of cells is just as easy.
  
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]
  
Excel to Custom DataTable
This sample shows how to utilize advanced APIs to dynamically build a custom DataTable from a worksheet range while ignoring hidden rows.
[Run Sample] | [C# Source] | [VB.NET Source] | [XLS]
Like SpreadsheetGear?
SpreadsheetGear 2010
Now Available
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.
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
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
The More I Use It
The More I Like It
"Thanks very much!

The more I understand and use SpreadsheetGear, the more I like it. Great job and excellent support."

Rob Stephens
RGS Consulting
Seattle, Washington
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.
Unmatched Speed
and Ease of Coding
Make it a Winner
SpreadsheetGear is a great product. The speed is unmatched and the ease of coding makes it a winner.

Steve Cruickshank
Redwood Software
Excellent Product
And Service
"Thank you for all your help during the trial period.

Your excellent product and service is what convinced us to buy this component."

Etienne Demers
OceanLogics, Canada
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
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
Brilliant Product
Fanatical Support
“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
Copyright © 2003-2011 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.