ImportDataTable from .xlsx file to a GridDataControl

[Benoit Lecue]

Hi everybody,

I'd like to have an information :)

Actually, i'd like to import datas, from a .xlsx files, into a GridDataControl. Unfortunately, i don't manage to do that.

The code seems to be :

DataTable myTable = dataSheet.ExportDataTable(dataSheet.UsedRange, ExcelExportDataTableOptions.ColumnNames);
DataSet _ds= new DataSet();
_ds.Tables.Add(dt);
grid.Itemssource = _ds.Tables[0];

The UsedRange is the good one so I thought it will works but no..

Here is my XAML:








And i join u my simple .xlsx file.

Hope u can help me.

Thanks a lot.

Regards.



File_6f6c39b7.rar

[Kamalakannan A]

Hi Benoit,

Sorry for the delay caused.

The GridDataControl does not support to import data from the Excel and display the same.

Please let us know if you need any other information.

Thanks
Kamal