StringBuilder sb = new StringBuilder ();
Sb. appendLine ("<table> <tr> <th> NO. </th> <th> batch Ticket No. </th> <th> Policy No. </th> <th> insured </th> <th> preservation project </th> <th> refund amount </th> <th> preservation operation date </th> <th> handled by </th> </tr> ");
Int I = 1;
String str = "abc ";
String str1 = "wanglei ";
String str2 = "aaa ";
String time1 = DateTime. Now. ToString ();
Sb. appendLine ("<tr> <td> 1 </td> <td style = \" vnd. ms-excel.numberformat: @ \ ">" + 243123 + "</td> <td style = \" vnd. ms-excel.numberformat: @ \ ">" + str + "</td> <td>" + str1 + "</td> <td>" + str2 + "</td> <td> "+" </td> <td> "+ time1 +" </td> <td> "+ str +" </td> </tr> ");
// Foreach (BillChange change in list)
//{
// Sb. appendLine ("<tr> <td>" + (I ++ ). toString () + "</td> <td style = \" vnd. ms-excel.numberformat: @ \ ">" + change. changeBillCode + "</td> <td style = \" vnd. ms-excel.numberformat: @ \ ">" + change. billCode + "</td> <td>" + change. billHolder + "</td> <td>" + GetChangeTypeString (change. changeType) + "</td> <td>" + (change. returntasks> 0? Change. returnlogs. toString (): "") + "</td> <td>" + change. createDatetime. toString ("yyyy-MM-dd") + "</td> <td>" + change. creatorName + "</td> </tr> ");
//}
Sb. insert (0, "Sb. AppendLine ("</table> </body> Response. Clear ();
Response. Buffer = true;
Response. Charset = "UTF-8 ";
Response. AppendHeader ("Content-Disposition", "attachment; filename = \" "+ Server. UrlEncode (" Change ticket information. xls ") + "\"");
Response. ContentEncoding = Encoding. UTF8;
Response. ContentType = "application/ms-excel ";
Response. Write (sb. ToString ());
Response. End ();
From the wanglei_smartfish Column