Download file with ClosedXML

by

The SaveAs() method supports stream, so to get the ClosedXml workbook as a stream I use:

public Stream GetStream(XLWorkbook excelWorkbook)
{
    Stream fs = new MemoryStream();
    excelWorkbook.SaveAs(fs);
    fs.Position = 0;
    return fs;
}

And then for downloading the file:

string myName = Server.UrlEncode(ReportName + "_" + DateTime.Now.ToShortDateString() + ".xlsx");
MemoryStream stream = GetStream(ExcelWorkbook);

Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=" + myName);
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(stream.ToArray());
Response.End();

More Related Contents:

  1. How to use __doPostBack()
  2. Can’t get Czech characters while generating a PDF
  3. How to check a input IP fall in a specific IP range
  4. What is the difference between PreserveReferencesHandling and ReferenceLoopHandling in Json.Net?
  5. Async Void, ASP.Net, and Count of Outstanding Operations
  6. HttpContext.Current.Session is null when routing requests
  7. Check if datetime instance falls in between other two datetime objects
  8. Read excel file from a stream
  9. sending mail along with embedded image using asp.net
  10. Share Session between two web sites using asp.net and state server
  11. {version} wildcard in MVC4 Bundle
  12. Get the current user, within an ApiController action, without passing the userID as a parameter
  13. Running an asynchronous operation triggered by an ASP.NET web page request
  14. Built-in helper to parse User.Identity.Name into Domain\Username
  15. Are static variables thread-safe? C#
  16. When Should I Use Response.Redirect(url, true)?
  17. Could not load file or assembly ‘System.Web.Helpers, error on IIS 8
  18. Why does HttpWebRequest throw an exception instead returning HttpStatusCode.NotFound?
  19. Multiple signalR connections/hubs on your website
  20. ASP.NET – AppDomain.CurrentDomain.GetAssemblies() – Assemblies missing after AppDomain restart
  21. WebAPI Request Streaming support
  22. ASP.Net page enter key causing post back
  23. ‘Session’ does not exist in the current context
  24. Asp.Net Routing: How do I ignore multiple wildcard routes?
  25. Count total rows of gridview with pagination
  26. Get a list of weeks for a year – with dates
  27. An error occurred attempting to determine the process id of dotnet.exe which is hosting your application. One or more error occured
  28. Lost Focus method for asp.net textbox?
  29. Reset scroll position after Async postback – ASP.NET
  30. How do you modify a CSS style in the code behind file for divs in ASP.NET?

Leave a Comment