change the Titles, in xls, free edtion.

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

change the Titles, in xls, free edtion.

Postby Domanet@mail.com » 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

Re: change the Titles, in xls, free edtion.

Postby harry.support » 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

Who is online

Users browsing this forum: No registered users and 1 guest