hi,
The goal is just to display excel file in a grid.
i use Infragistics.Excel.Workbook.Load to load my xls file into a workbook
then i get my worksheet (my xls file is only made of 1 sheet) but at this step i don't find a way to "convert" my worksheet into a Datasource to be added to my datagridview.
can you help me ?
There is no way to do this automatically, but Andrew Flick wrote a blog post about how to do this manually: http://blogs.infragistics.com/blogs/andrew_flick/archive/2007/08/31/excel-i-o.aspx