ExportToCSV - Retain users' custom column sorting?

[Brandon]

When exporting data from a RadGridView to a .csv file using the ExportToCSV class, I'd like the resulting .csv file to be sorted to match what the users have on their grid. For example, if a user were to drag a column on the grid to the far left, I'd expect that column to appear first in the .csv file after exporting. Is there a simple way to accomplish this?

Thanks in advance!

[Dinko | Tech Support Engineer]

Hi Brandon,

The ExportToCSV class is an old mechanism for exporting the control to csv. It is better to use the GridViewSpreadExport functionality which exposes a way to export the control to different formats: xlsx, csv, pdf and txt.  GridViewSpreadExport utilizes our RadSpreadProcessing library which is way more feature-rich and exposes different ways to manipulate the exported data.

Now I have tested this with the GridViewSpreadExport and the column order is respected when exporting the control to a CSV file. You can find my test project attached to this reply. I hope that my reply is helpful.

Regards,
Dinko | Tech Support Engineer
Progress Telerik

[Brandon]

Thanks for the help and the example! We've got it working in our project.