DataTable to Excel and back to DataTable RRS feed

  • Question

  • Involved in a data cleansing project.

    Looking for the best way to get some data (in a .net datatable) into Excel, allow the users to edit cells, add columns, use functions, delete rows etc and then get the clean data back into a DataTable.

    I am struggling to find a clean and simple route for this.

    CSV is a pain and if you load XML to Excel it won't let you use functions in the resultant table (even accepting that you only want the resultant value back in the DataTable not, obviously, the function itself).

    Open to ideas?

    Wednesday, February 24, 2016 7:21 PM


All replies