导出到Excel -安装Office自定义在MVC4

本文关键字：Office 自定义 MVC4 安装 Excel | 更新日期: 2023-09-27 18:07:25

我在MVC4应用程序中导出excel文件。
Excel 

public class ExporttoExcel : ActionResult
{
public GridView ExcelGridView { get; set; }
public string fileName { get; set; }
public int totalQuantity;
public decimal totalPrice1;
public string x1;
public ExporttoExcel(GridView gv, string pFileName, int totalQty, decimal totalPrice, string x)
{
  x1= x;
  ExcelGridView = gv;
  fileName = pFileName;
  totalQuantity = totalQty;
  totalPrice1 = totalPrice;
}
    public override void ExecuteResult(ControllerContext context)
    {
    HttpContext curContext = HttpContext.Current;
    curContext.Response.Clear();
    curContext.Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
    curContext.Response.Charset = "";
    curContext.Response.Cache.SetCacheability(HttpCacheability.NoCache);
    curContext.Response.ContentType = "application/vnd.ms-excel";      
    StringWriter sw = new StringWriter();
    HtmlTextWriter htw = new HtmlTextWriter(sw);
    if (x1== "111")
    {
      htw.WriteLine("<html><head>");
      //code logic
      ExcelGridView.HeaderStyle.BackColor = Color.Yellow;
      ExcelGridView.RenderControl(htw);
      htw.WriteLine("</body></html>");
    }
    else
    {
      htw.WriteLine("Data");
      ExcelGridView.RenderControl(htw);
    }
    byte[] byteArray = Encoding.ASCII.GetBytes(sw.ToString());
    MemoryStream s = new MemoryStream(byteArray);
    StreamReader sr = new StreamReader(s, Encoding.ASCII);
    curContext.Response.Write(sr.ReadToEnd());
    curContext.Response.End();
    }
}

出现以下错误，未打开excel文件

Error : 
From: file:///d:/Program Files/Microsoft Visual Studio 10.0/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.LoadTestExcelAddIn.vsto did not succeed.


我代码中的任何错误。我应该怎么做才能解决这个错误??
编辑:
此错误仅在IE中出现。Firefox和Chrome打开excel文件

导出到Excel -安装Office自定义在MVC4

我将这三个文件添加到本地机器中指定错误的位置。

Microsoft.VisualStudio.QualityTools.LoadTestExcelAddIn.dll
Microsoft.VisualStudio.QualityTools.LoadTestExcelAddIn.dll.manifest
Microsoft.VisualStudio.QualityTools.LoadTestExcelAddIn

运行正常，IE打开Excel文件

相关文章：