Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application

();

                app.Workbooks.Add();

       

                Microsoft.Office.Interop.Excel.Worksheet sheet = app.ActiveSheet;

                sheet.Cells[5, "B"] = "会员卡号";

                sheet.Cells[5, "C"] = "姓名";

                sheet.Cells[5, "D"] = "性别";

                sheet.Cells[5, "E"] = "电话";

                sheet.Cells[5, "F"] = "会员等级";

                sheet.Cells[5, "G"] = "登记时间";

                //sheet.get_Range(sheet.Cells[5, "E"]).set_ColumnWidth(60);

                //sheet.get_Range(sheet.Cells[5, "G"]).set_ColumnWidth(60);

                int rowIndex = 5;

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

                {

                    rowIndex++;

                    sheet.Cells[rowIndex, "B"] = dt.Rows[i]["MC_CardID"].ToString();

                    sheet.Cells[rowIndex, "C"] = dt.Rows[i]["MC_Name"].ToString();

                    var Sex = "男";

                    if (int.Parse(dt.Rows[i]["MC_Sex"].ToString()) == 2)

                    {

                        Sex = "女";

                    }

                    sheet.Cells[rowIndex, "D"] = Sex;

                    sheet.Cells[rowIndex, "E"] = dt.Rows[i]["MC_Mobile"].ToString();

                    sheet.Cells[rowIndex, "F"] = dt.Rows[i]["CL_LevelName"].ToString();

                    sheet.Cells[rowIndex, "G"] = dt.Rows[i]["MC_CreateTime"].ToString();

                }

                Response.Clear();

                Response.Buffer = true;

                Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString

("yyyyMMddhhmmss") + ".xlsx");

                Response.ContentEncoding = System.Text.Encoding.UTF8;

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

                return Json(true, JsonRequestBehavior.AllowGet);

            }

            catch (Exception e)

            {

                return RedirectToAction("Index", "Error", e);

            }

        }