/// <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"));
}
