What's the best way to export/import a DataTable object to Excel?

[Nicholas]

So I have a DataTable object that has data with rows & columns. My question is do I convert that into a RadGridView and then try to export it to Excel? Is that the easiest way to do it? Or is there another way I can export the DataTable object without having to convert it to a RadGridView? If so, how can I go about doing that? Is it using RadSpreadStreamProcessing library?

[Dess | Tech Support Engineer, Principal]

Hello, Nicholas, 

Converting a DataTable to an Excel file is more like a general programming question. Hence, I would recommend you to have a look at forums like MSDN and StackOveflow for additional information. The following threads are quite useful on this topic:
https://stackoverflow.com/questions/8207869/how-to-export-datatable-to-excel
https://social.msdn.microsoft.com/Forums/vstudio/en-US/ab1e15ef-8020-4ff6-9a84-2a728737b0e9/export-dataset-to-excel-on-winform?forum=csharpgeneral
https://www.codeproject.com/Questions/662975/Export-Datatable-to-excel

As to the RadGridView control, you can bind it to a DataTable and then use the GridViewSpreadExport.

I hope this information helps. If you have any additional questions, please let me know. 

Regards,
Dess
Progress Telerik