Hi,
Is there a option to Import data in excel sheet and display the same in WebGrid ?
Regards,
Abhi
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.
Thank you for the information.. Please let me know if I can find the code any where ?
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.