该方法试用与2003与2007,可以导出多个SHEET.不会有乱码.具体如下:
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
this.repPrj.RenderControl(hw); //repPrj为Control的ID,经过我的实验,Control可以为自定义控件,服务器端控件,客户端控件.
string[] strHTML = {sw.ToString()};//为数组,如果想导出多个SHEET;则用上面的方法做多个输出流.
string[] strSheetNames = {};//每个SHEET的名字,支持中文.
string fileName;
ExportToExcelInMIME(this.Response,fileName,strHTML,strSheetNames);
public static void ExportToExcelInMIME(HttpResponse rs,string fileName,string[] strHtmls,string[] strSheetsName)
{
rs.ContentType = "application/vnd.ms-excel";
rs.Charset = "utf-8";
rs.ContentEncoding = System.Text.Encoding.UTF8 ;
string name = HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);//如有乱码,可以调试该处的编码格式
rs.AppendHeader("Content-Disposition", "inline;filename=" + name + ".xls");
strSheetsName = StrToASC(strSheetsName).Split(',');
string strResult = CreateExcel(strHtmls,strSheetsName);
rs.Write(strResult.ToString().Replace("<a href=# ", "<p "));
rs.End();
}
public static string CreateExcel(string[] strHtmls,string[] strSheetsName)
{
string strResult = "";
strResult = CreateExcelHead(strSheetsName);
for(int i=0 ; i<strSheetsName.Length ; i++)
{
strResult += CreateExcelBoundary(strHtmls[i],i.ToString());
}
strResult += "--"+ SysConsts.Boundary +"--";
return strResult;
}
public static string CreateExcelHead(string[] strSheetsName)
{
StringBuilder sb = new StringBuilder();
sb.Append("MIME-Version: ");
sb.Append(SysConsts.MIMEVersion);
sb.Append("/r/nX-Document-Type: ");
sb.Append(SysConsts.DocumentType);
sb.Append("/r/nContent-Type: ");
sb.Append(SysConsts.ContentType);
sb.Append("; boundary=/"");
sb.Append(SysConsts.Boundary);
sb.Append("/"/r/n");
sb.Append("/r/n");
sb.Append("------BOUNDARY_9527----/r/n");
sb.Append("Content-Location: file:///C:/0E8D990C/MimeExcel.xml/r/n");
sb.Append("Content-Transfer-Encoding: quoted-printable/r/n");
sb.Append("Content-Type: text/html; charset=/"us-ascii/"/r/n");
sb.Append("/r/n");
sb.Append("/r/n<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");
sb.Append("xmlns=3D/"http://www.w3.org/TR/REC-html40/">/r/n");
sb.Append("<head>/r/n");
sb.Append("<xml>/r/n");
sb.Append("<x:ExcelWorkbook>/r/n");
sb.Append(" <x:ExcelWorksheets>/r/n");
for(int i=0 ; i<strSheetsName.Length ; i++)
{
sb.Append(" <x:ExcelWorksheet>/r/n");
sb.Append(" <x:Name>").Append(strSheetsName[i].ToString()).Append("</x:Name>/r/n");
sb.Append(" <x:WorksheetSource HRef=3D/"cid:sheet").Append(i.ToString()).Append("/"/>/r/n");
sb.Append(" </x:ExcelWorksheet>/r/n");
}
sb.Append(" </x:ExcelWorksheets>/r/n");
sb.Append("</x:ExcelWorkbook>/r/n");
sb.Append("</xml>/r/n");
sb.Append("</head>/r/n");
sb.Append("</html>/r/n");
return sb.ToString();
}
public static string CreateExcelBoundary(string strHtml,string strSheetName)
{
StringBuilder sb = new StringBuilder();
sb.Append("/r/n--").Append(SysConsts.Boundary).Append("/r/n");
sb.Append("Content-ID: sheet").Append(strSheetName).Append("/r/n");
sb.Append("Content-Transfer-Encoding: utf-8/r/n");//如有乱码,可以调试该处的编码格式
sb.Append("Content-Type: text/html; charset=/"utf-8/"/r/n");//如有乱码,可以调试该处的编码格式
sb.Append("/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");
sb.Append("xmlns=3D/"http://www.w3.org/TR/REC-html40/">/r/n");
sb.Append("<head>/r/n");
sb.Append("<xml>/r/n");
sb.Append(" <x:WorksheetOptions>/r/n");
sb.Append(" <x:ProtectContents>False</x:ProtectContents>/r/n");
sb.Append(" <x:ProtectObjects>False</x:ProtectObjects>/r/n");
sb.Append(" <x:ProtectScenarios>False</x:ProtectScenarios>/r/n");
sb.Append(" </x:WorksheetOptions>/r/n");
sb.Append("</xml>/r/n");
sb.Append("</head>/r/n");
sb.Append("<body>/r/n");
sb.Append ("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
sb.Append(strHtml);
sb.Append("/r/n</body>/r/n");
sb.Append("</html>/r/n");
// sb.Append("------BOUNDARY_9527------/r/n");
return sb.ToString();
}
/// <summary>
/// 将字符串转换为asc码
/// </summary>
/// <param name="rs"></param>
/// <param name="grid"></param>
/// <param name="fileName"></param>
public static string StrToASC(string str)
{
string acs = " ";
foreach(char a in str)
{
int i = (int)a;
acs += "&#"+i.ToString()+";";
}
return acs;
}
/// <summary>
/// 将字符串数组转换为asc码
/// </summary>
/// <param name="rs"></param>
/// <param name="grid"></param>
/// <param name="fileName"></param>
public static string StrToASC(string [] str)
{
string str1 = "";
foreach(string a in str)
{
str1 += StrToASC(a)+",";
}
str1 = str1.TrimEnd(',');
return str1;
}