Export Data table into excel using asp.net c#

// Copy an excel file on sever
-->> test.xlsx or test.xls


// Code in C#

protected void Export_DataTable_To_Excel(DataTable dtRecords)

    {

        string XlsPath = Server.MapPath(@"~/test.xlsx");

        string attachment = string.Empty;

        if (XlsPath.IndexOf("\\") != -1)

        {

            string[] strFileName = XlsPath.Split(new char[] { '\\' });

            attachment = "attachment; filename=" + strFileName[strFileName.Length - 1];

        }

        else

            attachment = "attachment; filename=" + XlsPath;

        try

        {

            Response.ClearContent();

            Response.AddHeader("content-disposition", attachment);

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

            string tab = string.Empty;

            foreach (DataColumn datacol in dtRecords.Columns)

            {

                Response.Write(tab + datacol.ColumnName);

                tab = "\t";

            }

            Response.Write("\n");

            foreach (DataRow dr in dtRecords.Rows)

            {

                tab = "";

                for (int j = 0; j < dtRecords.Columns.Count; j++)

                {

                    Response.Write(tab + Convert.ToString(dr[j]));

                    tab = "\t";

                }

                Response.Write("\n");

            }

            Response.End();

        }

        catch (Exception ex)

        {

            //Response.Write(ex.Message);

        }

    }