Importing data from RadSpreadsheet to a DataSet is possible. All you have to do is enumerate all cells in a row and write each value in a field. You can get the value of a cell using the following approach:
ICellValue value =
After you perform this for every cell in the current row you will be able to fill one row in the data set.
The reverse operation works almost the same. You enumerate the dataset's rows and then for each column you set the corresponding cell. Here is some code for setting the value:
While doing this displaying the RadSpreadsheet is not necessary. You can manipulate the spreadsheet in code behind and then export it to .xlsx. You will need references to the following assemblies to do that:
the Telerik team