??? ??? ???? ??? ???? Excel? ???? Excel(xlsx) ??? ?? ??? MIME ??? ????? ??? ?? ????

??? ?????? Excel ??? ??? ??? ???? ????. ?? ???? ??? HTML ??? ???? ?? ??? ?????. ?? ??? ??? ?? ???? ??? CSV ?? HTML ??? ????? ?? Excel?? ?? ??? ??? ? ????.

EPPlus? ???? ?? Excel ??? ??? ?? ?? ? ?????. EPPlus? LoadFromDataTable ? LoadFromCollection? ???? DataTable ?? ?? ???? ???? Excel ??? ?? ? ????. ??? ?? ? ?? ?? ??? ???? ?????.

public ActionResult ExportData()
{
    // Load data into a DataTable
    
    using (ExcelPackage package = new ExcelPackage())
    {
        var ws = package.Workbook.Worksheets.Add("My Sheet");
        // true generates headers
        ws.Cells["A1"].LoadFromDataTable(dataTable, true);

        var stream = new MemoryStream();
        package.SaveAs(stream);

        string fileName = "myfilename.xlsx";
        string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

        stream.Position = 0;
        return File(stream, contentType, fileName);
    }
}

LoadFromDataTable ? LoadFromCollection? ???? ??? ???? ? ??? ? ?? Excel ? ??? ?????.

var range = ws.Cells["A1"].LoadFromDataTable(table);
range.Style.Numberformat.Format = "#,##0.00";
range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;

?? , ??? ? ???? ??? ? ????:

ws.Cells[1,1].LoadFromDataTable(table, true, TableStyles.Light1);

??, ??, ?? ??? ? ??? ??? ?? ?????? GitHub ???? ?? ? ????.

MemoryStream? ???? ?? ??? ??? ??(??? ? ?? ???? ??)? ?? ? ? ??? ???? ?? ? ????. ??? MVC ???? ?? FileResult? ???? ?? ???? ????. ???? EPPlus ???? ?? ??? FileResult? ???? ????.

public class EpplusResult: FileResult
{
    public EpplusResult(ExcelPackage package)
        : base("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
    {
        Package = package;
    }

    public ExcelPackage Package { get; private set; }

    protected override void WriteFile(HttpResponseBase response)
    {
        Package.SaveAs(response.OutputStream);
    }
}

?? ?? ???? ??? ??? ? ????.

public FileResult ExportData()
{
    ExcelPackage package = new ExcelPackage();
    var ws = package.Workbook.Worksheets.Add("My Sheet");       
    ...
    ws.Cells[1,1].LoadFromDataTable(table, true, TableStyles.Light1);

    return new EpplusResult(package){FileDownloadName = "SomeFile.xlsx"};
}

? ??? ??? MIME ?? ? ??? ???? DataTable ???? Excel(.xlsx) ??? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!