int intDataCount = myData.Tables[0].Rows.Count;

　　　　　　　Microsoft.Office.Interop.Excel.Application app = null;

            Microsoft.Office.Interop.Excel.Workbook workbook = null;

            Microsoft.Office.Interop.Excel.Worksheet sheet = null;

            object missing = System.Reflection.Missing.Value;     //     表示 System.Reflection.Missing 类的唯一实例。

            string strPath = string.Empty;

            string strFileName = string.Empty;

            try

            {

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

                app.Visible = false;        // 不显示，仅后台生成

                workbook = app.Workbooks.Add(true); // 如果打开已存在文件，这里用Open，保存使用Save

                                                    // 添加sheet的方法

                workbook.Worksheets.Add(missing, missing, missing, missing);

                // 修改sheet名的方法，注意sheet的下标从1开始

                sheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[];

                sheet.Name = "new sheet name";

                //想要将sheet的名称改为Sheet1,则需改

                // 添加sheet的方法

                // 注销 workbook.Worksheets.Add(missing, missing, missing, missing);

                // 中间不变

                //sheet.Name = "Sheet1";

                //添加标题

                app.Cells[, ] = strTitle;

                app.Cells[, ] = "项目名称：" + myData.Tables[].Rows[][“columnName”].ToString();

                //合并单元格

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[, ]).MergeCells = true;

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[, ]).MergeCells = true;

                //居中对齐

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[, ]).HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;

                //设置字体

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[, ]).Font.Size = ;

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[, ]).HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;

                // 设置字体和大小

                //range = sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[rowCount, columnCount]);

                //range.Font.Name = “Arial”;

                //range.Font.Size = 10;

                // 设置单元格的wrap text属性

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[intDataCount + , ]).WrapText = true;

                // 设置单元格的数据格式为文本格式

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[intDataCount + , ]).NumberFormat = "@";

                //设置自动调整列宽

                sheet.get_Range(sheet.Cells[, ], sheet.Cells[intDataCount + , ]).EntireColumn.AutoFit();
　　　　　　　　　 //sheet.Range[sheet.Cells[1, 1], sheet.Cells[intDataCount + 1, 13]].EntireColumn.ColumnWidth = 20;

　　　　　　　　　　sheet.Range[sheet.Cells[1, 1], sheet.Cells[intDataCount + 1, 13]].WrapText = false;
　　　　　　　　　　sheet.Range[sheet.Cells[1, 1], sheet.Cells[intDataCount + 1, 13]].NumberFormat = "@";
　　　　　　　　　　sheet.Range[sheet.Cells[1, 1], sheet.Cells[intDataCount + 1, 13]].EntireRow.AutoFit();
　　　　　　　　　　sheet.Range[sheet.Cells[1, 1], sheet.Cells[intDataCount + 1, 13]].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;

                Microsoft.Office.Interop.Excel.Range range;

                Array arr = Array.CreateInstance(typeof(object), intDataCount + , );

                // 不断的调用下面的的函数填充array中的内容

                // 行,列均从0开始

                arr.SetValue("列名1", , );

                arr.SetValue("列名2", , );

                arr.SetValue("列名3", , );

                arr.SetValue("列名4", , );

                arr.SetValue("列名5", , );

                arr.SetValue("列名6", , );

                int i = ;

                foreach (DataRow row in myData.Tables[].Rows)

                {

                    arr.SetValue(row["columnName1"], i, );

                    arr.SetValue(row["columnName2"], i, );

                    arr.SetValue(row["columnName3"], i, );

                    arr.SetValue(row["columnName4"], i, );

                    arr.SetValue(row["columnName5"], i, );

                    arr.SetValue(row["columnName6"], i, );

                    i++;

                }

                // 设置array数据，注意选择的行数和列数要与array行数和列数对应

                //sheet.get_Range(sheet.Cells[, ], sheet.Cells[intDataCount + , ]).Value2 = arr;

　　　　　　　　　sheet.Range[sheet.Cells[1, 1], sheet.Cells[intDataCount + 1, 13]].Value2 = arr;

                // 这里给sheet填充内容部分略

                // 如果文件已经存在又不想让“是否替换”的提示窗体显示出来，需要先调用File.Delete来删除文件

                strFileName = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";

                strPath = Server.MapPath("~/upload");

                workbook.SaveAs(strPath + "\\" + strFileName, missing, missing, missing, missing, missing,

                Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, missing, missing,

                missing, missing, missing);

　　　　　　　　　　HylExcel.NavigateUrl = string.Format(@"{0}/{1}/{2}", PageBase.UrlBase, PageBase.UploadDir, strFileName);
　　　　　　　　　　HylExcel.Text = string.Format("<span style='color:red;font-weight:bold;'>点这里下载Excel文件{0}</span>", strFileName);

                workbook.Close(false, missing, missing);

                app.Quit();

                workbook = null;

                app = null;

                GC.Collect();

                //FileInfo fi = new FileInfo(strPath + "\\" + strFileName);//excelFile为文件在服务器上的地址

                //HttpResponse contextResponse = HttpContext.Current.Response;

                //contextResponse.Clear();

               // contextResponse.Buffer = true;

               //contextResponse.Charset = "GB2312"; //设置了类型为中文防止乱码的出现

               // contextResponse.AppendHeader("Content-Disposition", String.Format("attachment;filename={0}", fi.Name)); //定义输出文件和文件名

                ///contextResponse.AppendHeader("Content-Length", fi.Length.ToString());

               //contextResponse.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

                //contextResponse.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 

                //contextResponse.WriteFile(fi.FullName);

               // contextResponse.Flush();

                //fi.Delete();

            }

            catch (Exception ex)

            {

                if (app != null)

                {

                    app.Quit();

                    app = null;

                    GC.Collect();

                }

            }