C#使用Aspose.Cells导出Excel简单实现

 1 /// 

 2 /// 导出Excel表格
 3 /// 
 4 /// 数据集合
 5 /// 数据表头
 6 /// 
 7 public void ExportExcel(DataTable dt, string[] header)
 8 {
 9     Workbook wb = new Workbook(FileFormatType.Xlsx);
10     try
11     {
12         Worksheet sheet = wb.Worksheets[0];
13         sheet.Name = "MO上行查询结果";
14         if (dt.Rows.Count alert(‘没有检测到需要导出数据!‘);");
17             return;
18         }
19         // 为单元格添加样式
20         Aspose.Cells.Style style = wb.CreateStyle();
21         style.HorizontalAlignment = Aspose.Cells.TextAlignmentType.Center;  //设置居中
22         style.Font.Size = 12;//文字大小
23         style.Font.IsBold = true;//粗体
24         style.HorizontalAlignment = TextAlignmentType.Center;//文字居中
25 
26         int rowIndex = 0;
27         for (int i = 0; i alert(‘导出异常:" + e.Message + "!‘);");
45     }
46     #region 输出到Excel
47     using (MemoryStream ms = new MemoryStream())
48     {
49 
50         wb.Save(ms, new OoxmlSaveOptions(SaveFormat.Xlsx));//默认支持xls版，需要修改指定版本
51         System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
52         System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
53         System.Web.HttpContext.Current.Response.BinaryWrite(ms.ToArray());
54         wb = null;
55         System.Web.HttpContext.Current.Response.End();
56     }
57     #endregion
58 }