Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Fri Sep 16, 2011 8:00 pm

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

Domanet@mail.com
 
Posts: 1
Joined: Fri Sep 16, 2011 5:34 pm

Mon Sep 19, 2011 8:10 am

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.
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar

harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Return to Spire.DataExport