Excel? ??? ??????

?????? Excel ??? ??? ??? ???? ?? ???? ???? HTML ??? ??? ??? ?????. . Excel? ?? ??? ? ?? ?? ??? ???? ???? ??? csv ?? HTML ??? ????? ?????.

EPPlus? ?? ?????? ???? ??? Excel ??? ??? ?? ?? ????.
I ??? ??? ?? ?? ??? ????? ????? Excel ??? ???? ??? xlsx? ?? ??? ??? ??? ???? ??? ?? ???? ??? ?? ? ????. file.

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

public ActionResult ExportData()
{

    //Somehow, load data to 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;

?? ??? ?? ????. ??? ???? ??? ????? ??? ???? LoadFromDataTable ?? LoadFromCollection? ?????. ?:

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

?????? Gitup ??? ?? ?? ??, ?? ??, ?? ??? ??, ??? ?? ?? ?????.

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

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

        Package = package;
    }

    public ExcelPackage Package { get; private set; }

    protected override void WriteFile(HttpResponseBase response)
    {
        // grab chunks of data and write to the output stream
        Stream outputStream = response.OutputStream;
        using (Package)
        {
            Package.SaveAs(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"};
}

? ??? EPPlus? ???? ???? Excel ??? ????? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!