protected FileContentResult ExportExcelBase(DataTable table, string fileName, string strHeaderText = null)
{
string dt = DateTime.Now.ToString("yyyyMMddHHmmss");
string headerName = string.IsNullOrEmpty(fileName) ? dt : fileName;
if (string.IsNullOrEmpty(fileName))
{
fileName = dt + ".xls";
}
else
{
fileName = fileName + ".xls";
}
//ie 需要编码
if (string.Compare(Request.Browser.Browser, "IE", true) == 0 || string.Compare(Request.Browser.Browser, "InternetExplorer", true) == 0)
{
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
}
var export = new ExcelExport();
return(File(export.ExportExcelFromDataTable(table, headerName).GetBuffer(),
"application/vnd.ms-excel", fileName));
}
