本地导出Excel 正常,但是部署到到服务器后,html格式全部消失,只剩下数据,如下图:
public void ToExcelByString(string strValue, string fname)
{
if (!string.IsNullOrEmpty(strValue))
{
Response.Clear();
Response.Buffer = true;
EnableViewState = false;
//Response.Charset = "gb2312";
//Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
//Response.ContentType = "application/ms-excel";
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fname, System.Text.Encoding.UTF8) + ".xls");
Response.Write(strValue);
Response.End();
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "click", "ymPrompt.alert('提示:暂无数据!',null,null,'系统提示',null)", true);
}
}
这是我的导出代码