Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();

                excel.Visible = true;

                //新增加一个工作簿，Workbook是直接保存，不会弹出保存对话框，加上Application会弹出保存对话框，值为false会报错

                excel.Application.Workbooks.Add(true);

                //生成Excel中列头名称

                excel.Cells[, ] = "姓名";

                excel.Cells[, ] = "工号";

                excel.Cells[, ] = "公司";

                excel.Cells[, ] = "部门";

                excel.Cells[, ] = "失败原因";

                //把newdt当前页的数据保存在Excel中

                for (int i = ; i < newdt.Rows.Count; i++)

                {

                    excel.Cells[i + , ] = "'" + newdt.Rows[i]["Emp_Name"];

                    excel.Cells[i + , ] = "'" + newdt.Rows[i]["Emp_Code"];

                    excel.Cells[i + , ] = "'" + newdt.Rows[i]["CompanyName"];

                    excel.Cells[i + , ] = "'" + newdt.Rows[i]["DeptName"];

                    excel.Cells[i + , ] = "'" + newdt.Rows[i]["Error"];

                }

                //设置禁止弹出保存和覆盖的询问提示框

                excel.DisplayAlerts = false;

                excel.AlertBeforeOverwriting = false;

                //保存工作簿

                excel.Application.Workbooks.Add(true).Save();

                //保存excel文件

                excel.Save("D:" + "\\错误信息.xls");

                //确保Excel进程关闭

                excel.Quit();

                excel = null;

        /// <summary>

        /// 导出数据到本地

        /// </summary>

        /// <param name="dt">要导出的数据</param>

        /// <param name="Name">标题</param>

        /// <param name="path">保存路径</param>

        public void OutFileToDisk(DataTable dt, string Name, string path)

        {

            Workbook workbook = new Workbook();

            /* 工作簿 */

            Worksheet sheet = workbook.Worksheets[];                               /* 工作表 */

            Cells cells = sheet.Cells;                                          /* 单元格 //为标题设置样式 */

            Style styleTitle = workbook.Styles[workbook.Styles.Add()];               /* 新增样式 */

            Style style2 = workbook.Styles[workbook.Styles.Add()];                                  /* 新增样式 */

            style2.HorizontalAlignment = TextAlignmentType.Center;     /* 文字居中 */

            style2.Font.Name = "宋体";                         /* 文字字体 */

            style2.Font.Size = ;                           /* 文字大小 */

            style2.Font.IsBold = true;                         /* 粗体 */

            style2.IsTextWrapped = true;                         /* 单元格内容自动换行 */

            style2.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;

            style2.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;

            style2.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;

            style2.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;          /* 样式3 */

            Style style3 = workbook.Styles[workbook.Styles.Add()];                                  /* 新增样式 */

            style3.HorizontalAlignment = TextAlignmentType.Center;     /* 文字居中 */

            style3.Font.Name = "宋体";                         /* 文字字体 */

            style3.Font.Size = ;                           /* 文字大小 */

            style3.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;

            style3.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;

            style3.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;

            style3.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;

            int Colnum = dt.Columns.Count;     /* 表格列数 */

            int Rownum = dt.Rows.Count;

            /* 生成行2 列名行 */

            for (int i = ; i < Colnum; i++)

            {

                cells[, i].PutValue(dt.Columns[i].ColumnName);

                cells[, i].SetStyle(style2);

                cells.SetRowHeight(, );

                cells.SetColumnWidth(i, );

            }

            /* 生成数据行 */

            for (int i = ; i < Rownum; i++)

            {

                for (int k = ; k < Colnum; k++)

                {

                    cells[ + i, k].PutValue(dt.Rows[i][k].ToString());

                    cells[ + i, k].SetStyle(style3);

                }

                cells.SetRowHeight( + i, );

            }

            //workbook.Save(path);//可以通过Save直接存储

            MemoryStream ms = workbook.SaveToStream();

            byte[] bt = ms.ToArray();

            string fileName = Name + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";//客户端保存的文件名

            //以字符流的形式下载文件

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

            //通知浏览器下载文件而不是打开

            Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));

            Response.BinaryWrite(bt);

            Response.Flush();

            Response.End();

        }