change the Titles, in xls, free edtion.

[Domanet@mail.com]

Export datatable to excel.

Can I change the Titles?

E.G Datatable colums names Name_Test,Name_Test1,Name_Test2,Name_Test4 can I display Name,PostCode,Phone,Closed

[harry.support]

Thanks for your inquiry.

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

1. SqlCommand, please us sql column alias to change the column header.
eg: select Name_Test as Name, Name_Test1 as PostCode, Name_Test2 as Phone, Name_Test4 as Closed
from ...
2. DataTable, please change the column header of the DataTable.