Hi i know two waies to export to xls
first : loop to DataTable and create manauly then write it to response.
<pre lang="cs">Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls");
second : use exporters link Devexpress ASPXGridExporter.
<pre lang="c#">
protected void imbPersonsXLS_Click(object sender, ImageClickEventArgs e)
{
GridExporterPersons.WriteXlsToResponse();
}
the second way is very easy and devexpress aspxgridview filter also suported.