سلام

برای گرفتن خروجی اکسل از کد زیر استفاده میکنم:

protected void ExportToExcel_Click(object sender, EventArgs e)
{
    var products = GetProducts();
    ExcelPackage excel = new ExcelPackage();
    var workSheet = excel.Workbook.Worksheets.Add("Products");
    var totalCols = products.Columns.Count;
    var totalRows = products.Rows.Count;

    for (var col = 1; col <= totalCols; col++)
    {
        workSheet.Cells[1, col].Value = products.Columns[col-1].ColumnName;
    }
    for (var row = 1; row <= totalRows; row++)
    {
        for (var col = 0; col < totalCols; col++)
        {
            workSheet.Cells[row + 1, col + 1].Value = products.Rows[row - 1][col];
        }
    }
    using (var memoryStream = new MemoryStream())
    {
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
        Response.AddHeader("content-disposition", "attachment;  filename=products.xlsx");
        excel.SaveAs(memoryStream);
        memoryStream.WriteTo(Response.OutputStream);
        Response.Flush();
        Response.End();
    }
}

public DataTable GetProducts()
{
    using (var conn  = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindContext"].ConnectionString))
    using (var cmd = new SqlCommand("SELECT * FROM Products", conn))
    using (var adapter = new SqlDataAdapter(cmd))
    {
        var products = new DataTable();
        adapter.Fill(products);
        return products;
    }
}

حالا میخوام امکان خروجی عکس هم به آن اضافه کنم.

مثالهایی که دیدم جوابگو نبودن هیچکدام