Write to CSV file and export it?

by

Rom, you’re doing it wrong. You don’t want to write files to disk so that IIS can serve them up. That adds security implications as well as increases complexity. All you really need to do is save the CSV directly to the response stream.

Here’s the scenario: User wishes to download csv. User submits a form with details about the csv they want. You prepare the csv, then provide the user a URL to an aspx page which can be used to construct the csv file and write it to the response stream. The user clicks the link. The aspx page is blank; in the page codebehind you simply write the csv to the response stream and end it.

You can add the following to the (I believe this is correct) Load event:

string attachment = "attachment; filename=MyCsvLol.csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");

var sb = new StringBuilder();
foreach(var line in DataToExportToCSV)
  sb.AppendLine(TransformDataLineIntoCsv(line));

HttpContext.Current.Response.Write(sb.ToString());

writing to the response stream code ganked from here.

More Related Contents:

  1. Export DataTable to Excel File
  2. How to create CSV Excel file C#? [closed]
  3. Sending an array of values to Oracle procedure to use in WHERE IN clause
  4. Is csv with multi tabs/sheet possible?
  5. System.IndexOutOfRangeException: Cannot find table 0
  6. Procedure or function xxxxx has too many arguments specified [duplicate]
  7. Reach control from another page. ASP.Net
  8. How to get current user timezone in c#
  9. Access a Remote Directory from C#
  10. Pass C# ASP.NET array to Javascript array
  11. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  12. What is the difference between Server.MapPath and HostingEnvironment.MapPath?
  13. Displaying standard DataTables in MVC
  14. Add Header and Footer for PDF using iTextsharp
  15. Unable to connect to ASP.Net Development Server issue
  16. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  17. How to create roles in ASP.NET Core and assign them to users?
  18. How do I see the raw HTTP request that the HttpWebRequest class sends?
  19. How to export C# methods?
  20. Timer in UpdatePanel
  21. How can I convert ticks to a date format?
  22. How do I route images using ASP.Net MVC routing?
  23. Convert a string’s character encoding from windows-1252 to utf-8
  24. Javascript serialization of DateTime in asp.net is not giving a javascript date object?
  25. Login page on different domain
  26. Best practice for error handling with ASP.NET Web API
  27. Place watermark image on other images (C#, ASP.Net)
  28. Populate TreeView from DataBase
  29. How to intercept any postback in a page? – ASP.NET
  30. AuthenticateRequest event

Leave a Comment