/// <summary> /// 导出Excel(带表头) /// </summary> /// <returns></returns> public IActionResult ExportExcelByTitle(string name = null) { var data = GetData(); var fileName = $"测试导出"; var excelwork = new ExcelWorker(); var bytes = excelwork.ExportDataTable(data, fileName, name == null?"测试表头":name); return(File(bytes, "application/x-xls", fileName + ".xls")); }
/// <summary> /// 导出Excel(不带表头) /// </summary> /// <returns></returns> public IActionResult ExportExcel() { var data = GetData(); var fileName = $"测试导出"; var excelwork = new ExcelWorker(); var bytes = excelwork.ExportDataTable(data, fileName); return(File(bytes, "application/x-xls", fileName + ".xls")); }