Download the List to a local file and save it as Excel.

Source: Internet
Author: User

Directly attach code

1 /// <summary> 2 /// Save the List as Excel 3 /// </summary> 4 /// <typeparam name = "T"> Save the class type </typeparam> 5 // <param name = "lt"> source data to be saved </param> 6 /// <param name = "fileName"> File name </param> 7 // <param name = "fields"> corresponding to the field name of the class </param> 8 /// <param name = "titles"> name of the column in Excel </param> 9 public static void Save <T> (List <T> lt, string fileName, string [] fields, string [] titles) 10 {11 if (lt = null | lt. count = 0) 12 {13 throw new ArgumentNullException ("data is empty"); 14} 15 16 var sb = new StringBuilder (); 17 PropertyInfo [] props = typeof (T ). getProperties (BindingFlags. public | BindingFlags. instance); 18 const string next = "\ t"; 19 20 foreach (var title in titles) 21 {22 sb. append (title ). append (next); 23} 24 25 var propertys = new List <PropertyInfo> (); 26 27 foreach (var field in fields) 28 {29 foreach (PropertyInfo prop in props) 30 {31 if (prop. name. equals (field) 32 {33 propertys. add (prop); 34 break; 35} 36} 37} 38 39 sb. append (Environment. newLine); 40 41 foreach (T item in lt) 42 {43 foreach (var property in propertys) 44 {45 object value = property. getValue (item, null); 46 47 if (property. propertyType. baseType = typeof (Enum) 48 {49 sb. append (GPMSKernel. unility. enums. getEnumDescription (value); 50} 51 else if (property. propertyType = typeof (Boolean) 52 {53 if (bool) value) 54 {55 sb. append ("yes"); 56} 57 else58 {59 sb. append ("no"); 60} 61} 62 else63 {64 sb. append (value); 65} 66 67 sb. append (next); 68} 69 70 sb. append (Environment. newLine); 71} 72 73 fileName = string. format ("1_01__1_12.16.xls", DateTime. now. toString ("yyMMddHHmmss"), fileName); 74 HttpContext. current. response. contentType = "application/octet-stream"; 75 // notify the browser to download the file instead of opening 76 HttpContext. current. response. addHeader ("Content-Disposition", "attachment; filename =" + HttpUtility. urlEncode (fileName, Encoding. UTF8); 77 HttpContext. current. response. binaryWrite (Encoding. UTF8.GetBytes (sb. toString (); 78 HttpContext. current. response. flush (); 79 HttpContext. current. response. end (); 80}

This method downloads the List from the Web server to a local file and saves it as an Excel file, where lt is the data source to be saved and fileName is the corresponding file name, you can directly write it as the name of the class to be saved,

Fields corresponds to the field name of the class to be saved. This must be correct. Otherwise, this field cannot be found in the class. titles is the name of the column in the file to be saved, fields and titles must correspond to each other, and the number must be equal.
Special processing is performed before saving. For example, if an enumeration exists in the class to be saved, it will be saved to Excel in English. This is generally not what you want to see, note [Description ("***")] before each enumerated value.
GPMSKernel. unility. enums. getEnumDescription can obtain the Description value of the enumeration. If it is a Boolean value, it is saved as "True" or "False, I converted this type to "yes" or "no". If there are special classes in the class to be saved, we need to rewrite the ToString method in this special class, the ToString method will be used to save the data ....

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.