ecexl操作

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68

/// <summary> /// 写入ecexl /// </summary> /// <param name="dt"></param> /// <param name="FileName"></param> public static void CreateExcel(DataTable dt, string FileName) {       HttpResponse resp = HttpContext.Current.Response;       resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");       resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls");       string colHeaders = string.Empty;       string ls_item = string.Empty;       DataRow[] myRow = dt.Select();       int cl = dt.Columns.Count;       for (int i = 0; i < cl; i++)     {         if (i < 4)         {             if (i == 3)             {                 colHeaders += dt.Columns[i].Caption.ToString() + "\n";             }               else             {                 colHeaders += dt.Columns[i].Caption.ToString() + "\t";             }         }     }       resp.Write(colHeaders);       foreach (DataRow dr in myRow)     {           for (int j = 0; j < cl; j++)         {             if (j < 4)             {                 if (j == 3)                 {                     ls_item += Hostname2ip(dr[j - 1].ToString()) + "\n";                 }                   else                 {                     ls_item += dr[j].ToString() + "\t";                 }             }         }       }       resp.Write(ls_item);       ls_item = string.Empty;       resp.End();   }