​The example below demonstrates Telerik SPRadGrid's new capability - displaying data from excel files stored in document libraries.

 

 

 Books

 
Drag a column header and drop it here to group by that column
ProductIDProductNameSupplierIDCategoryIDQuantityPerUnitUnitPriceUnitsInStockUnitsOnOrder
Data pager
Data pager
123
Page size:
PageSizeComboBox
select
 29 items in 3 pages
1Chai1310 boxes x 20 bags18.00390
2Chang1724 - 12 oz bottles19.001740
3Aniseed Syrup1212 - 550 ml bottles10.001370
4Chef Anton's Cajun Seasoning2 48 - 6 oz jars22.00530
5Chef Anton's Gumbo Mix2236 boxes21.3500
6Grandma's Boysenberry Spread3212 - 8 oz jars25.001200
7Uncle Bob's Organic Dried Pears3712 - 1 lb pkgs.30.00150
8Northwoods Cranberry Sauce3212 - 12 oz jars40.0060
9Mishi Kobe Niku4618 - 500 g pkgs.97.00290
10Ikura4812 - 200 ml jars31.00310
  • Sort Ascending
  • Sort Descending
  • Clear Sorting
  • Group By
  • Ungroup
  • Columns
  • Filter
    • select
      select

To point the grid to the Excel file it should be bound to, use SPRadGrid Designer from the web part menu:

excel_web_part_menu.png

From the top left tree view select the MasterTableView node (Note: hierarchy is not supported with excel binding). Click the DataBinding node from the bottom left tree view and when the SQL, Excel and SharePoint Lists explorers load - select the Excel tab:

excel_explorer.png

The Excel explorer will list the document libraries in the current SharePoint web and will display only the excel files (if any) within those. Select the document library you are interested in and click on the excel file that should provide data for the grid. Upon clicking on the excel file a small panel will be displayed that allows you to specify the cell range and sheet name containing the data:

excel_range.png

Note: it might take some time for the sheet names to load as the SharePoint Excel Service is used for that behind the scene.

The first row in the cell range selected will be treated as column names. If it is empty - the columns will be given default names. Once the range and the sheet name have been specified, just press the Save Web Part button.