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

2 posts, 0 answers
  1. Nicholas
    Nicholas avatar
    12 posts
    Member since:
    Nov 2017

    Posted 22 Mar 2018 Link to this post

    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?

  2. Dess | Tech Support Engineer, Sr.
    Dess | Tech Support Engineer, Sr.  avatar
    4086 posts

    Posted 26 Mar 2018 Link to this post

    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:

    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. 

    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top