public static byte[] GetExecl(DataTable dt, List<string> list)

        {

            var sbHtml = new StringBuilder();

            sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0'>");

            sbHtml.Append("<tr>");

            foreach (var item in list)

            {

                sbHtml.AppendFormat("<td style='font-size: 14px;text-align:center;background-color: #DCE0E2; font-weight:bold;' height='25'>{0}</td>", item);

            }

            sbHtml.Append("</tr>");

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

            {

                sbHtml.Append("<tr>");

                for (int j = ; j < list.Count; j++)

                {

                    sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", dt.Rows[i][j].ToString());

                }

                sbHtml.Append("</tr>");

            }

            sbHtml.Append("</table>");

            byte[] fileContents = Encoding.Default.GetBytes(sbHtml.ToString());

            return fileContents;

        }

public FileResult ExportExcel(int page,int PageSize,string CusName="")

        {

            var orderby = "order by Createdate desc";

            var wherestr = "";

            //要导出的字段

            var tablefield = "ID,CusName,CusShort,Salesman,Industry,CusType,CusAdrss,Region,CusContact,"

                + "CusIphone,CusMobile,FinName,FinIphone,FinMail,FinFax,Qqnumber,BankAccount,"

                + "BankDeposit,TariffItem,TpayerDate,Contracttime,Remark,VerifierYes,"

                + "Verifier,Verifierdate,Creater,Createdate,Updater,Updatedate";

            if (CusName != "")

            {

                wherestr = "and CusName like '%" + CusName + "%'";

            }

            //得到要导出的数据

            DataSet ds = DAL.SQLBasic.GetDateSetfengye(PageSize, page, tablename, wherestr, orderby, tablefield);

            //设置execl第一行标题

            List<string> list = new List<string> { "客户编号","客户名称","客户简称",

                "所属业务员","行业","客户类型","客户地址","区域","指定联系人",

                "联系人电话","联系人手机","财务员","财务员电话","财务员邮箱","财务员传真","财务员QQ","银行账号",

                "开户行","税号","成为纳税人时间","合同有效期","备注","是否审核",

                "审核人","审核时间","创建人","创建时间","修改人","修改时间"};

            byte[] fileContents = Utilitiy.ExcelHelper.GetExecl(ds.Tables[], list);

            return File(fileContents, "application/ms-excel", "客户信息.xls");

        }