代码
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Text;
namespace Web
{
public partial class excel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
/// <summary>
/// Get Image's Code In Base64 Code Format.
/// </summary>
/// <param name="path"></param>
/// <param name="strCode"></param>
/// <returns></returns>
private static string GetImageCodeInBase64(string path)
{
string strImgCodeInBase64 = "";
FileStream file;
byte[] base64buffer; //开辟缓冲区
// 打开图片文件，利用该图片构造一个文件流
file = new FileStream(path, FileMode.Open);
base64buffer = new byte[(int)file.Length];
BinaryReader br = new BinaryReader(file, Encoding.UTF8);
br.Read(base64buffer, 0, (int)file.Length);
strImgCodeInBase64 = Convert.ToBase64String(base64buffer);
return strImgCodeInBase64;
}
protected void Button1_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("MIME-Version: 1.0\r\n");
sb.Append("X-Document-Type: Worksheet\r\n");
sb.Append("Content-Type: multipart/related; boundary=\"----=mtrSystem\"\r\n\r\n\r\n");
sb.Append("------=mtrSystem\r\n");
sb.Append("Content-Type: text/html; charset=\"utf-8\"\r\n");
sb.Append("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\r\n");
sb.Append("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\">\r\n\r\n\r\n");
sb.Append("<head></head><body>\r\n");
sb.Append("<table border=\"1\" width=3D\"600\"><tr height=3D\"51\"><td><img src=\"cid:baiduimg\"></td><td><img src=\"cid:cnblogsimg\" width=3D\"200\"></td><td>dfasdfasdf</td></tr><tr height=3D\"51\"><td></td><td></td></table>\r\n");
sb.Append("</body></html>\r\n\r\n");
sb.Append("------=mtrSystem\r\n");
sb.Append("Content-ID: baiduimg\r\n");
sb.Append("Content-Transfer-Encoding: base64\r\n");
sb.Append("Content-Type: image/jpeg\r\n\r\n");
sb.Append(GetImageCodeInBase64(Server.MapPath("./logo-yy.gif")) + "\r\n\r\n\r\n\r\n");
sb.Append("------=mtrSystem\r\n");
sb.Append("Content-ID: cnblogsimg\r\n");
sb.Append("Content-Transfer-Encoding: base64\r\n");
sb.Append("Content-Type: image/png\r\n\r\n");
sb.Append(GetImageCodeInBase64(Server.MapPath("./MIME_XLS.png")) + "\r\n\r\n\r\n");
sb.Append("------=mtrSystem--\r\n");
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
string name = HttpUtility.UrlEncode(DateTime.Now.ToString("yyyyMMddhhmmssss"), System.Text.Encoding.UTF8);
Response.AppendHeader("Content-Disposition", "inline;filename=" + name + ".xls");
Response.Write(sb.ToString());
Response.End();
}
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Text;
namespace Web
{
public partial class excel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
/// <summary>
/// Get Image's Code In Base64 Code Format.
/// </summary>
/// <param name="path"></param>
/// <param name="strCode"></param>
/// <returns></returns>
private static string GetImageCodeInBase64(string path)
{
string strImgCodeInBase64 = "";
FileStream file;
byte[] base64buffer; //开辟缓冲区
// 打开图片文件，利用该图片构造一个文件流
file = new FileStream(path, FileMode.Open);
base64buffer = new byte[(int)file.Length];
BinaryReader br = new BinaryReader(file, Encoding.UTF8);
br.Read(base64buffer, 0, (int)file.Length);
strImgCodeInBase64 = Convert.ToBase64String(base64buffer);
return strImgCodeInBase64;
}
protected void Button1_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("MIME-Version: 1.0\r\n");
sb.Append("X-Document-Type: Worksheet\r\n");
sb.Append("Content-Type: multipart/related; boundary=\"----=mtrSystem\"\r\n\r\n\r\n");
sb.Append("------=mtrSystem\r\n");
sb.Append("Content-Type: text/html; charset=\"utf-8\"\r\n");
sb.Append("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\r\n");
sb.Append("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\">\r\n\r\n\r\n");
sb.Append("<head></head><body>\r\n");
sb.Append("<table border=\"1\" width=3D\"600\"><tr height=3D\"51\"><td><img src=\"cid:baiduimg\"></td><td><img src=\"cid:cnblogsimg\" width=3D\"200\"></td><td>dfasdfasdf</td></tr><tr height=3D\"51\"><td></td><td></td></table>\r\n");
sb.Append("</body></html>\r\n\r\n");
sb.Append("------=mtrSystem\r\n");
sb.Append("Content-ID: baiduimg\r\n");
sb.Append("Content-Transfer-Encoding: base64\r\n");
sb.Append("Content-Type: image/jpeg\r\n\r\n");
sb.Append(GetImageCodeInBase64(Server.MapPath("./logo-yy.gif")) + "\r\n\r\n\r\n\r\n");
sb.Append("------=mtrSystem\r\n");
sb.Append("Content-ID: cnblogsimg\r\n");
sb.Append("Content-Transfer-Encoding: base64\r\n");
sb.Append("Content-Type: image/png\r\n\r\n");
sb.Append(GetImageCodeInBase64(Server.MapPath("./MIME_XLS.png")) + "\r\n\r\n\r\n");
sb.Append("------=mtrSystem--\r\n");
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
string name = HttpUtility.UrlEncode(DateTime.Now.ToString("yyyyMMddhhmmssss"), System.Text.Encoding.UTF8);
Response.AppendHeader("Content-Disposition", "inline;filename=" + name + ".xls");
Response.Write(sb.ToString());
Response.End();
}
}
}