asp.net Excel汇出方法
Response.ClearHeaders();
Response.Clear();
Response.Expires = 0;
Response.Buffer = true;
Response.Charset = "UTF-8";
//把 attachment 改为 online 则在线打开
Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + FileName + "\"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
string[] keyValue = sFileName.Split(".".ToCharArray());
if (keyValue.Length >= 2)
{
string type = (string)((keyValue[keyValue.Length - 1]).ToString());
Response.ContentType = GetResponseContentType(type);
}
//获取byte格式文件从数据库
byte[] bt = (byte[])DownLoadFile(Convert.ToDateTime(Server.UrlDecode(Request["SaveTime"])));
if (bt.Length == 0)
{
byte[] tempArray = new byte[1];
tempArray[0] = Convert.ToByte(' ');
bt = tempArray;
}
Response.OutputStream.Write(bt, 0, bt.Length);
Response.OutputStream.Flush();
Response.OutputStream.Close();
Response.Flush();
Response.End();
Response.Clear();
Response.Expires = 0;
Response.Buffer = true;
Response.Charset = "UTF-8";
//把 attachment 改为 online 则在线打开
Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + FileName + "\"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
string[] keyValue = sFileName.Split(".".ToCharArray());
if (keyValue.Length >= 2)
{
string type = (string)((keyValue[keyValue.Length - 1]).ToString());
Response.ContentType = GetResponseContentType(type);
}
//获取byte格式文件从数据库
byte[] bt = (byte[])DownLoadFile(Convert.ToDateTime(Server.UrlDecode(Request["SaveTime"])));
if (bt.Length == 0)
{
byte[] tempArray = new byte[1];
tempArray[0] = Convert.ToByte(' ');
bt = tempArray;
}
Response.OutputStream.Write(bt, 0, bt.Length);
Response.OutputStream.Flush();
Response.OutputStream.Close();
Response.Flush();
Response.End();
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25897606/viewspace-712515/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle 内外连接 join 总结
请登录后发表评论
登录
全部评论
