用输出流导出EXCEL,在2007下打开乱码问题

来源：互联网发布：windows telent 编辑：程序博客网时间：2024/05/21 10:26

该方法试用与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;
  }