Import Worksheet into DataTable

Hello,

Is there a possibilty to import a worksheet directly/by code into a DataTable (without using UltraGrid) to find/select a row with a given value?

Or is there any way to filter a worksheet by code to find a row with a given value?

Thanks for your help!

Hello Olaf,

Thank you for posting in our forum.

You do not need UltraGird to import data form Excel workbook to DataTable. Actually the main aim of the grid is to visualize the data.

To import data from Excel workbook you may use Infragistics Excel engine. More about this you may find by following the next link http://help.infragistics.com/Doc/WinForms/current/CLR4.0/?page=Win_Infragistics_Excel_Engine.html.

Please check also the attached small sample project showing you how you can iterate the information in an Excel worksheet and populate it in a data table.

Thank you for using Infragistics Controls.