数据源导入EXCEL

 

 private void createExcel(List<VSalesOrder> list)
    {

        StringBuilder sb = new StringBuilder();
        sb.Append("<table width=800 border=0><tr><td width=200 align=\"center\">订单号</td><td width=100 align=\"center\">日期</td><td width=100 align=\"center\">交货方式</td width=100 align=\"center\"><td width=100 align=\"center\">结算方式</td><td width=100 align=\"center\">顾客名称</td><td width=100 align=\"center\">合计金额</td> <td width=100 align=\"center\">状态</td></tr>");
         int len=list.Count;

         for (int i = 0; i < len; i++)
         {
             VSalesOrder vs = list[i];
            
             sb.Append(" <tr>");
             sb.Append("<td>"+vs.SalesOrderID+"</td>");
             sb.Append("<td>"+vs.CreateDate+"</td>");
             sb.Append("<td>" + vs.DeliveryType + "</td>");
             sb.Append("<td>" + vs.ClosingType + "</td>");
             sb.Append("<td>" + vs.CustomerName + "</td>");
             sb.Append("<td>" + vs.SalesIncome.ToString() + "</td>");
             sb.Append("<td>" + changString(vs.State.ToString()) + "</td>");
             sb.Append(" </tr>");
         }
         sb.Append("</table>");

         string path = System.Web.HttpContext.Current.Server.MapPath("../UploadFiles/" + DateTime.Now.Tostring("yyyyMMdd") + ".xls");
         FileStream NewText = File.Create(path);
         NewText.Close();

         FileStream TextFile = File.Open(path, FileMode.Append);
       
         TextFile.Write((System.Text.Encoding.Default.GetBytes(sb.ToString().ToCharArray())), 0, System.Text.Encoding.Default.GetBytes(sb.ToString().ToCharArray()).Length);
         TextFile.Close();*/
         Response.Clear();
         Response.Buffer = true;
         Response.Charset = "GB2312";
         Response.AppendHeader("Content-Disposition", "attachment;filename=" + "I" + DateTime.Now.ToString("yyyyMMdd") + ".xls");
         Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文  
         Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。       
         System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
         System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
         System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
         oStringWriter.Write(sb.ToString());
         Response.Write(oStringWriter.ToString());
         Response.End(); 

 

    }