???? Excel? ???? ??

??? ???? ???? ??? HTML ??? ???? ?? ??? ?? ??? ??? ?? ?? ? ?? ??? ??? ? ????. Excel? ??? ??? ???? ?????. ? ???? ??? EPPlus? ?? ?????? ???? ?? Excel ??? ??? ????.

EPPlus ??

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

?? ??:

public ActionResult ExportData()
{
    DataTable dataTable = GetData(); // Method to retrieve data

    using (ExcelPackage package = new ExcelPackage())
    {
        var ws = package.Workbook.Worksheets.Add("My Sheet");
        ws.Cells["A1"].LoadFromDataTable(dataTable, true); // Load with true to include headers

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

?? ? ??? ??:

???? ???? Excel? ??? ??? ???? ???? ??? ? ????. ??:

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

?? ??? ??:

??? ??? ??? ? ???? ??? ????? ?? ??? ????? 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)
    {
        using (Package)
        {
            Package.SaveAs(response.OutputStream);
        }
    }
}

? ??? ?? ??? ?????? ??? ? ????. action:

public FileResult ExportData()
{
    ExcelPackage package = new ExcelPackage();
    var ws = package.Workbook.Worksheets.Add("My Sheet");
    ... // Load and format data

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

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

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