Visit Our Facebook Page
Visit Our Google Plus Page
Visit Our Twitter Page
What's New
ASP.NET, Windows Forms and Silverlight SpreadsheetGear Samples
Purchase SpreadsheetGear
Download SpreadsheetGear

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 2012 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.


This sample shows how to retrieve data from a Microsoft Excel workbook and display it in an ASP.NET DataGrid control.

This sample shows how to retrieve data from multiple worksheets in a Microsoft Excel workbook and display it in multiple ASP.NET DataGrid controls.

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.

This sample shows how to utilize the IRange.Copy method to dynamically copy and consolidate data from multiple workbooks.

This sample shows how to utilize advanced APIs to dynamically build a custom DataTable from a worksheet range while ignoring hidden rows.