读取数据写入xls

View Code 
 1 public void ExportDB()
 2         {
 3 //条件查询 得到数据
 4             var data = InvoiceBLL.List(startTime, endTime, statuslist);
 5 
 6             Response.Clear();
 7 
 8             Response.BufferOutput = true;
 9 
10 
11             Workbook wb = new Workbook();
12             wb.DefaultStyle.Font.Size = 12;
13 
14             Worksheet ws = wb.Worksheets[0];
15 
16             ws.Name = "发送记录";
17 
18 
19 
20             DataTable dt = new DataTable();
21 
22             dt.Columns.Add("单位名称");
23             dt.Columns.Add("客户类型");
24             dt.Columns.Add("联系人");
25             dt.Columns.Add("实际金额");
26             dt.Columns.Add("开票金额");
27             dt.Columns.Add("到款银行");
28             dt.Columns.Add("到款日期");
29             dt.Columns.Add("员工");
30 
31             foreach (var mobilSendLog in data)
32             {
33 
34                 dt.Rows.Add(mobilSendLog.InvoiceUnitName, mobilSendLog.UnitType.ToString(), mobilSendLog.ContactFullName, mobilSendLog.Money, mobilSendLog.InvoiceMoney, mobilSendLog.BankType, mobilSendLog.InvoiceTime, CRMComm.GetUserName(mobilSendLog.BusinessUser));
35 
36             }
37 
38             ws.Cells.ImportDataTable(dt, true, "A1");
39 
40             if (Request.UserAgent.ToLower().Contains("msie"))
41 
42                 wb.Save(System.Web.HttpUtility.UrlEncode("[财务统计].xls", System.Text.Encoding.UTF8), FileFormatType.Excel2003, SaveType.OpenInExcel, this.Response);
43 
44             else
45 
46                 wb.Save("[财务统计].xls", FileFormatType.Excel2003, SaveType.OpenInExcel, this.Response);
47 
48             Response.Flush();
49 
50             Response.End();
51 
52         }
posted @ 2012-11-15 09:43  /╱× 丫 丶  阅读(114)  评论(0)    收藏  举报