Is there a way to use a Worksheet "Or Convert it to" a dataSource that would be compatible with RadGridView?
I'm currently working on building a list from the activeWorksheet but it cause multiple issues "Header name, Columns Type, ect..
1 Answer, 1 is accepted
answered on 25 Dec 2017, 09:25 AM
RadGridView control is semantically different from the model of RadSpreadProcessing. RadGridView works by binding a collection of data to it and shows it in a table manner. Workbooks, on the other hand, are a whole structure and binding each cell would not be possible.
That said, you could iterate over the contents of the workbook and create a collection applicable as the source of the RadGridView. RadGridView should recognize the column names as headers if they are properly set as column names in a DataTable. You could also take a look at the "Get, Set and Clear Cell Properties" and "Cell Value Types" articles for some additional information on the cell properties and cell value types.