Export DB table into .xls working but getting an error !!

Question

Dear All,

 

i am working on the below code and it's loading the table's data into excel (.xls) file but while exporting giving an error as attached. when i am converting this code into .csv then the data are moving to next column when it finds the coma values i.e.

Employee_FullName

Marek,John 

 

--Excel 

HttpContext context = HttpContext.Current;

context.Response.Clear();

foreach (DataColumn column in dataTable.Columns)

{

context.Response.Write(column.ColumnName + "\t");

}

context.Response.Write(Environment.NewLine);

foreach (DataRow row in dataTable.Rows)

{

for (int i = 0; i < dataTable.Columns.Count; i++)

{

context.Response.Write(row[i].ToString() + "\t");

}

context.Response.Write(Environment.NewLine);

}

context.Response.ContentType = "application/ms-excel";

context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".xls");

context.Response.End();

 

--CSV

 

HttpContext context = HttpContext.Current;

context.Response.Clear();

foreach (DataColumn column in dataTable.Columns)

{

context.Response.Write(column.ColumnName + ",");

}

context.Response.Write(Environment.NewLine);

foreach (DataRow row in dataTable.Rows)

{

for (int i = 0; i < dataTable.Columns.Count; i++)

{

context.Response.Write(row[i].ToString() + ",");

//context.Response.Write(row[i].ToString().Replace(";", string.Empty) + ";");

}

context.Response.Write(Environment.NewLine);

}

context.Response.ContentType = "application / ms - excel";

context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");

context.Response.End();