How to change the column headers

[jay2success]

Hi, i am very interested in this great component, i have applied the sample and i can do exporting, here are the problems:
1. I want to use custom header names, the original ones from datasource is not informative, please tell me how can i change the column header.
2. I noticed there is headers properties but i can't add per columns, instead it will add per rows
3. I noticed there is titles properties but when i change it, nothing happened.

The point is i want to change the column header names on all exporting, please tell me how. Thanks.

[harry.support]

Hi,

Thanks for your inquiry.
If the DataSource of your export component object (e.g. CellExport) is

SqlCommand, please us sql column alias to change the column header.

DataTable, please change the column header of the DataTable.

[jay2success]

Thanks for your reply.

Is there any other way? I already tried your method, before it export, i changed the datatable column name but it slows down the export significantly, for datatable column name, i am using small caps with hypen character, for the export i want to use more familiar and easier name and changing the datatable column name slows down the export process. Please suggest other ways.

[harry.support]

Hi,

Thanks for your inquiry.
Would you please tell us which file format you want to export to?