Hi,
I use the following code to export data to an excel file:
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=test.xls");
while (reader.Read())
{
string name = "";
string email = "";
if (reader[colN ...
Go to the complete details ...