// respone攔截器
service.interceptors.response.use(
 response => {
 // blob類型為文件下載對(duì)象，不論是什么請(qǐng)求方式，直接返回文件流數(shù)據(jù)
 if (response.config.responseType === 'blob') {
  const fileName = decodeURI(
  response.headers['content-disposition'].split('filename=')[1]
  )
// 返回文件流內(nèi)容，以及獲取文件名, response.headers['content-disposition']的獲取, 默認(rèn)是獲取不到的,需要對(duì)服務(wù)端webapi進(jìn)行配置
  return Promise.resolve({ data: response.data, fileName: fileName })
 }
 // 依據(jù)后端邏輯實(shí)際情況，需要彈窗展示友好錯(cuò)誤
 },
 error => {
 let resp = error.response
 if (resp.data) {
  console.log('err:' + decodeURIComponent(resp.data)) // for debug
 }
 // TODO: 需要依據(jù)后端實(shí)際情況判斷
 return Promise.reject(error)
 }
)

exportExcel () {
  let params = {}
  let p = this.getQueryParams() // 獲取相應(yīng)的參數(shù)
  if (p) params = Object({}, params, p)
  axios
  .get('接口地址', {
   params: params,
   responseType: 'blob'
  })
  .then(res => {
   var blob = new Blob([res.data], {
   type: 'application/vnd.ms-excel;charset=utf-8'
   })
   // 針對(duì)于IE瀏覽器的處理, 因部分IE瀏覽器不支持createObjectURL
   if (window.navigator && window.navigator.msSaveOrOpenBlob) {
   window.navigator.msSaveOrOpenBlob(blob, res.fileName)
   } else {
   var downloadElement = document.createElement('a')
   var href = window.URL.createObjectURL(blob) // 創(chuàng)建下載的鏈接
   downloadElement.href = href
   downloadElement.download = res.fileName // 下載后文件名
   document.body.appendChild(downloadElement)
   downloadElement.click() // 點(diǎn)擊下載
   document.body.removeChild(downloadElement) // 下載完成移除元素
   window.URL.revokeObjectURL(href) // 釋放掉blob對(duì)象
   }
  })
 }

[HttpGet]
  public IHttpActionResult ExportData([FromUri]Pagination pagination, [FromUri] OrderReqDto dto)
  {
   //取出數(shù)據(jù)源
   DataTable dt = this.Service.GetMemberPageList(pagination, dto.ConvertToFilter());
   if (dt.Rows.Count > 65535)
   {
    throw new Exception("最大導(dǎo)出行數(shù)為65535行,請(qǐng)按條件篩選數(shù)據(jù)！");
   }
   foreach (DataRow row in dt.Rows)
   {
    var isRealName = row["IsRealName"].ToBool();
    row["IsRealName"] = isRealName ? "是" : "否";
   }
   var model = new ExportModel();
   model.Data = JsonConvert.SerializeObject(dt);
   model.FileName = "會(huì)員信息";
   model.Title = model.FileName;
   model.LstCol = new List<ExportDataColumn>();
   model.LstCol.Add(new ExportDataColumn() { prop = "FullName", label = "會(huì)員名稱" });
   model.LstCol.Add(new ExportDataColumn() { prop = "RealName", label = "真實(shí)姓名" });
   model.LstCol.Add(new ExportDataColumn() { prop = "GradeName", label = "會(huì)員等級(jí)" });
   model.LstCol.Add(new ExportDataColumn() { prop = "Telphone", label = "電話" });
   model.LstCol.Add(new ExportDataColumn() { prop = "AreaName", label = "區(qū)域" });
   model.LstCol.Add(new ExportDataColumn() { prop = "GridName", label = "網(wǎng)格" });
   model.LstCol.Add(new ExportDataColumn() { prop = "Address", label = "門牌號(hào)" });
   model.LstCol.Add(new ExportDataColumn() { prop = "RegTime", label = "注冊時(shí)間" });
   model.LstCol.Add(new ExportDataColumn() { prop = "Description", label = "備注" });
   return ExportDataByFore(model);
  }

[HttpGet]
  public IHttpActionResult ExportDataByFore(ExportModel dto)
  {
   var dt = JsonConvert.DeserializeObject<DataTable>(dto.Data);
   var fileName = dto.FileName + DateTime.Now.ToString("yyMMddHHmmssfff") + ".xls";
   //設(shè)置導(dǎo)出格式
   ExcelConfig excelconfig = new ExcelConfig();
   excelconfig.Title = dto.Title;
   excelconfig.TitleFont = "微軟雅黑";
   excelconfig.TitlePoint = 25;
   excelconfig.FileName = fileName;
   excelconfig.IsAllSizeColumn = true;
   //每一列的設(shè)置,沒有設(shè)置的列信息，系統(tǒng)將按datatable中的列名導(dǎo)出
   excelconfig.ColumnEntity = new List<ColumnEntity>();
   //表頭
   foreach (var col in dto.LstCol)
   {
    excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = col.prop, ExcelColumn = col.label });
   }
   //調(diào)用導(dǎo)出方法
   var stream = ExcelHelper.ExportMemoryStream(dt, excelconfig); // 通過NPOI形成將數(shù)據(jù)繪制成Excel文件并形成內(nèi)存流
   var browser = String.Empty;
   if (HttpContext.Current.Request.UserAgent != null)
   {
    browser = HttpContext.Current.Request.UserAgent.ToUpper();
   }
   HttpResponseMessage httpResponseMessage = new HttpResponseMessage(HttpStatusCode.OK);
   httpResponseMessage.Content = new StreamContent(stream);
   httpResponseMessage.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream"); // 返回類型必須為文件流 application/octet-stream
   httpResponseMessage.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") // 設(shè)置頭部其他內(nèi)容特性, 文件名
   {
    FileName =
     browser.Contains("FIREFOX")
      ? fileName
      : HttpUtility.UrlEncode(fileName)
   };
   return ResponseMessage(httpResponseMessage);
  }