the file you are trying to open is in a different format than specified by the file extension in Asp.Net

by

I have used CloseXML to solve the problem.

public static void ExportToExcel(IEnumerable<dynamic> data, string sheetName)
{
    XLWorkbook wb = new XLWorkbook();
    var ws = wb.Worksheets.Add(sheetName);
    ws.Cell(2, 1).InsertTable(data);
    HttpContext.Current.Response.Clear();
    HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
    HttpContext.Current.Response.AddHeader("content-disposition", String.Format(@"attachment;filename={0}.xlsx",sheetName.Replace(" ","_")));

    using (MemoryStream memoryStream = new MemoryStream())
    {
        wb.SaveAs(memoryStream);
        memoryStream.WriteTo(HttpContext.Current.Response.OutputStream);
        memoryStream.Close();
    }

    HttpContext.Current.Response.End();
}

Installed ClosedXML in my project using Nuget Package Manager.

More Related Contents:

  1. How to export a CSV to Excel using Powershell
  2. How to create an Excel File with Nodejs?
  3. SumIf using Excel VBA
  4. How can I call a macro which contains a loop but only run one iteration of that loop?
  5. Convert matrix to 3-column table (‘reverse pivot’, ‘unpivot’, ‘flatten’, ‘normalize’)
  6. How can I find last row that contains data in a specific column?
  7. Copy from one workbook and paste into another
  8. Open Excel file for reading with VBA without display
  9. Last non-empty cell in a column
  10. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  11. How to remove all non alphanumeric characters from a string except period and space in excel?
  12. Find last used cell in Excel VBA
  13. Retrieving the COM class factory for component failed
  14. Does Dir() make any guarantee on the order of files returned?
  15. Call a Sub with a String
  16. Redirect from asp.net web api post action
  17. Assign on-click VBA function to a dynamically created button on Excel Userform
  18. PowerQuery: How can I concatenate grouped values?
  19. Using a wildcard to open an excel workbook
  20. ADODB Connection String for .csv
  21. Excel macro -Split comma separated entries to new rows [duplicate]
  22. Get text from clipboard using GetText – avoid error on empty clipboard
  23. Benchmarking VBA Code
  24. Pandas read_excel with Hyperlink
  25. Display milliseconds in Excel
  26. VBA editor auto-deletes spaces at the ends of lines
  27. Application.Quit command not closing the entire Excel Application
  28. Trying to open the workbook in separate instance
  29. Excel: Find min/max values in a column among those matched from another column
  30. Access files with long paths (over 260)

Leave a Comment