Display an Excel Range in GridView

[Raymond]

I am using the following code to get an array of values from Excel;

rng = ws.Range[sCell1, sCell2];
object dataRows = rng.Value;

I then try to bind the array to a GridView using;

gvText.ItemsSource = dataRows;

However I get the error; "Array was not a one-dimensional array".

I have tried converting the array to an observable collection;

ObservableCollection<object> colRows = new ObservableCollection<object>(dataRows);

but this displays the error; ​"The best overloaded method match for 'System.Collections.ObjectModel.ObservableCollection<object>.ObservableCollection(System.Collections.Generic.IEnumerable<object>)' has some invalid arguments".

How can I bind the Excel data returned to the grid?

[Ivan Ivanov]

Hi,

Range.Value is actually a two dimensional object-type array. You can iterate over it and write it in some more appropriate format. I have prepared a sample project that uses DynamicObject. You only have to change the file path to run it on your side.

Regards,
Ivan Ivanov
Telerik

 

 

[Raymond]

Thanks Ivan,

Won't have time to try this until tomorrow but will let you know how I go.

Regards,

Ray

[Raymond]

Hi Ivan,

Tried your solution and it worked a treat.  Thanks for your help.

Regards,

Ray