Export use Bound Column Field instead of Column Display Name

[Mark]

We need the ability to use the underline field for each column instead of the column display name as the field in the export file.  Our column display names are built dynamically and it is possible that we can have two columns display names being the same. Their underline properties will be the different, therefore, we want to use that in the export.  

 

Any help would be great.

 

Thanks

[Mark]

I hit send before I could fix the TITLE.  I need it for the COLUMN NAMES in the Export files.  

Sorry

 

[Dess | Tech Support Engineer, Principal]

Hello, Mark,

One possible solution that I can suggest is to change the header text of the columns just before executing the export action and restore the column names afterwards.

An alternative approach, in case you are using the GridViewSpreadExport which utilizes our RadSpreadProcessing library to export the content of RadGridView to xlsx, csv, pdf and txt formats, is to handle the ExportCompleted event which is triggered when the export operation completes. Once you have the exported grid data, you can benefit from the RadSpreadProcessing library, load the Excel file and change the columns names in the workbook:
https://docs.telerik.com/devtools/winforms/controls/gridview/exporting-data/spread-export 
https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-workbooks/create-open-and-save-workbooks 
https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-cells/accessing-cells-of-worksheet 

Feel free to use this approach which suits your requirements best.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Mark]

Yea, that's what I was afraid of.  I have a solution that is similar to that. While not ideal, it is working.   I was looking at the code and I don't see this being a huge change to the EXPORT feature.  Have a property that let's the user specify what to use for the column headers of the export file, either the Display Name or Field Name.  IMO, using the Display Name in a CSV export, is bad, for this exact reason, the possibility of having duplicate names in the Display Names of the columns.

Thanks for the help and have a great day.

[Dess | Tech Support Engineer, Principal]

Hello, Mark,

Thank you for the provided feedback.

We will definitely consider it in the future improvement of the export functionality that RadGridView offers if other customers have similar requests.

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik