[Solved] ASP.Net Error: Could not load file or assembly System.Numerics.Vectors

Hi,

I need Export ASP.Net GridView to XLSX (Excel) file using C#

I have this error

Could not load file or assembly 'System.Numerics.Vectors, Version=4.1.3.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileLoadException: Could not load file or assembly 'System.Numerics.Vectors, Version=4.1.3.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Source Error:


Line 399:        HttpContext.Current.Response.Cookies["guid"].Value + ".xlsx";
Line 400:
Line 401:        using (XLWorkbook wb = new XLWorkbook())
Line 402:        {
Line 403:            for (int i = 0; i < ds.Tables.Count; i++)

My code below

public static void ExportDataSetToExcel(DataSet ds)
{
    string AppLocation = @"D:\inetpub\wwwroot\public\ExcelFiles\";
    string guid = Guid.NewGuid().ToString().ToUpper().Replace("-", "_");
 
    HttpContext.Current.Response.Cookies["guid"].Value = guid.ToString();
    HttpContext.Current.Response.Cookies["guid"].Expires = DateTime.Now.AddMinutes(3);
 
    string filepath = AppLocation + "Export_" +
        DateTime.Now.ToString("ddMMyyyyHHmm") + "_" +
        HttpContext.Current.Response.Cookies["guid"].Value + ".xlsx";
 
    using (XLWorkbook wb = new XLWorkbook())
    {
        for (int i = 0; i < ds.Tables.Count; i++)
        {
            wb.Worksheets.Add(ds.Tables[i], ds.Tables[i].TableName);
        }
        wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
        wb.Style.Font.Bold = true;
        wb.SaveAs(filepath);
        wb.Dispose();
    }
 
    Thread.Sleep(3000);
    HttpContext.Current.Response.Clear();
    HttpContext.Current.Response.Buffer = true;
    HttpContext.Current.Response.ContentType = "application/force-download";
 
    HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=Export_" +
        DateTime.Now.ToString("ddMMyyyyHHmm") + "_" +
        HttpContext.Current.Response.Cookies["guid"].Value + ".xlsx");
 
    HttpContext.Current.Response.TransmitFile(@"D:\inetpub\wwwroot\public\ExcelFiles\Export_" +
        DateTime.Now.ToString("ddMMyyyyHHmm") + "_" +
        HttpContext.Current.Response.Cookies["guid"].Value + ".xlsx");
 
    HttpCookie cookie = new HttpCookie("ExcelDownloadFlag")
    {
        Value = "Flag",
        Expires = DateTime.Now.AddDays(1)
    };
 
    HttpContext.Current.Response.AppendCookie(cookie);
    HttpContext.Current.Response.End();
}

Web.config

<runtime>
  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
      <assemblyIdentity name="System.Runtime.CompilerServices.Unsafe" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
      <bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
    </dependentAssembly>
    <dependentAssembly>
      <assemblyIdentity name="System.Buffers" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
      <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
    </dependentAssembly>
    <dependentAssembly>
      <assemblyIdentity name="System.Numerics.Vectors" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
      <bindingRedirect oldVersion="0.0.0.0-4.1.4.0" newVersion="4.1.4.0" />
    </dependentAssembly>
    <dependentAssembly>
      <assemblyIdentity name="System.Memory" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
      <bindingRedirect oldVersion="0.0.0.0-4.0.1.2" newVersion="4.0.1.2" />
    </dependentAssembly>
  </assemblyBinding>
</runtime>