Aspose.Cells 导出 Excel

public HttpResponseMessage ExportRecord()
        {
            try
            {
                HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
                Workbook wb = new Workbook();
                Worksheet sheet = wb.Worksheets[0];
                sheet.Name = "sheetname";

                List<DTO> rowList;

                if (rowList.Count <= 0)
                {
                    System.Web.HttpContext.Current.Response.Write("<script>alert('没有检测到需要导出数据!');</script>");
                    return new HttpResponseMessage();
                }
                List<string> header = new List<string>();
                header = new List<string> { "列名1", "列名2", "列名3" };
                int rowIndex = 0;
                for (int i = 0; i < header.Count; i++)
                {
                    sheet.Cells[rowIndex, i].PutValue(header[i]);
                }

                for (int i = 0; i < rowList.Count; i++)
                {
                    sheet.Cells[i + 1, 0].PutValue(rowList[i].列名1);
                    sheet.Cells[i + 1, 1].PutValue(rowList[i].列名2);
                    sheet.Cells[i + 1, 2].PutValue(rowList[i].列名3.Value.ToString("yyyy-MM-dd hh:mm:ss:fff"));
                }

                #region 输出到Excel
                using (MemoryStream ms = new MemoryStream())
                {
                    wb.Save(ms, FileFormatType.Excel2003);
                    //两种方法
                    //方法1
                    //System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
                    //System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
                    //System.Web.HttpContext.Current.Response.BinaryWrite(ms.ToArray());
                    //wb = null;
                    //System.Web.HttpContext.Current.Response.End();

                    //方法2
                    wb = null;
                    response.Content = new ByteArrayContent(ms.ToArray());
                    response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
                    response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls" };
                }
                #endregion

                return response;
            }
            catch (Exception e)
            {
                System.Web.HttpContext.Current.Response.Write("<script>alert('导出异常:" + e.Message + "!');</script>");
                return new HttpResponseMessage();
            }
        }