参考自:https://blog.youkuaiyun.com/b6_g9/article/details/39970337
不过这里的日期格式化是,冒号会变成下划线,具体为什么我现在也没解决到,希望大家能够帮我指出原因,感谢感谢!
DateTime datetime = System.DateTime.Now;
//dddd-完整的星期几名称,MMMM-完整的月份名
string strFileName = string.Format("{0:yyyy-MM-dd HH:mm:ss}",datetime) + ".xls";
String pointMessage = "";
if (dt == null || dt.Rows.Count == 0)
{
pointMessage = "暂无数据,无法导出!";
Alert(pointMessage);
return;
}
else
{
HttpContext curContext = HttpContext.Current;
//设置编码及附件格式
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "utf-8";
string agent = "";
bool isEdge = false;
agent = Request.UserAgent;
//关键字Edge 是否Edge浏览器, MSIE 是否ie浏览器
if (