private void ExportFile(string type)
{
var exportdt = new DataTable();
exportdt.Columns.Add("標題", typeof(string));
var dr = exportdt.NewRow();
dr["標題"] = "的天傳民觀也。是效歡！書以善回票醫怎說病北話中！境病初看；達用要整要倒成差不綠們所問至。像產度上候……到經面獨裡向，最試代。的起得但然內型國中謝；力身發：育細長讀再大路現活自？海開清獲告表它連：我領？";
exportdt.Rows.Add(dr);
var fileName = "匯出_" + DateTime.Now.ToString("yyyyMMddHHmm");
switch (type)
{
case "EPPlus":
FilesHelper.ExportDatasToExcel(exportdt, fileName);
break;
case "EPPlusZip":
FilesHelper.ExportDatasToExcelZip(exportdt, fileName);
break;
case "MiniExcel":
var stream = new MemoryStream();
stream.SaveAs(exportdt);
fileName = HttpContext.Current.Server.UrlPathEncode(fileName);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + fileName + ".xlsx");
HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
HttpContext.Current.Response.BinaryWrite(stream.ToArray());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
break;
}
}
