Hi,
Is there a option to Import data in excel sheet and display the same in WebGrid ?
Regards,
Abhi
Not automatically, but you can parse the Excel sheet programatically using the classes in the Infragistics.Excel namespace and then populate the grid from there.
Thank you for the information.. Please let me know if I can find the code any where ?
abiram01,
If you create a Workbook object, you can use its Load() method to load an Excel file or stream into it. For more information on the Workbook.Load() method, take a look at the following page in our online documentation:
<http://help.infragistics.com/Help/NetAdvantage/NET/2008.1/CLR2.0/html/Infragistics2.Excel.v8.1~Infragistics.Excel.Workbook~Load.html>
If you click on either of the overload links, you will get more details on that particular overload.
I am not aware of a complete example anywhere, but it's not especially difficult. Just load the Excel file into a Workbook object, find the Worksheet your interested in, and iterate over the rows.