First let's see what the CSV file is:
CSV file is a text based file in which data are separated by comma. It can be opened by excel so you can use excel functionality. Each row of data including the title is in separate line. Meanwhile, each row has data separated by comma.
How to create a CSV file?
We need to write data to Response object. Meanwhile the content type should be text/csv also a header type of attachment should be added to response. Afterwards, column names are written to response then to actual data is written (each row should be just in one line).Finally you need to call Response.End to finalize your work.
Important: if any part of data has comma, unfortunately the CSV file will be screwed up. What I did in the code is that I am replacing comma with space so I am sure that the only comma exists in each row is just for separating data rather than being part of data.
public class CSVExporter { public static void WriteToCSV(List<Person> personList) { string attachment = "attachment; filename=PerosnList.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");
WriteColumnName();
foreach (Person item in personList) { WriteUserInfo(item); }
HttpContext.Current.Response.End(); }
private static void WriteUserInfo(Person item) { StringBuilder strb = new StringBuilder();
AddComma(item.Name, strb); AddComma(item.Family, strb); AddComma(item.Age.ToString(), strb); AddComma(string.Format("{0:C2}", item.Salary), strb);
HttpContext.Current.Response.Write(strb.ToString()); HttpContext.Current.Response.Write(Environment.NewLine); }
private static void AddComma(string item, StringBuilder strb) { strb.Append(item.Replace(',', ' ')); strb.Append(" ,"); } private static void WriteColumnName() { string str = "Name, Family, Age, Salary"; HttpContext.Current.Response.Write(str); HttpContext.Current.Response.Write(Environment.NewLine); } } |