How Export Graph With Gridview Data Into Export To Excel

   //this below  code we can export graph with data but after few minutes image of graph disappear from Excel sheet when excel closed.

Msg Showing Linked Image can not be displayed.The file may have been moved,renamed,or deleted.verify that the link points to the correct file and location

Please Guide me where need to chnage or Where is wrong

        DataTable dthdr = dt;
        string FileName = FileNames;

        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.ClearContent();
        HttpContext.Current.Response.ClearHeaders();
        HttpContext.Current.Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");

        HttpContext.Current.Response.Charset = "";
     

        //sets font

        HttpContext.Current.Response.Write("");
        HttpContext.Current.Response.Write("


");
        //sets the table border, cell spacing, border color, font of the text, background, foreground, font height
        HttpContext.Current.Response.Write("

          "borderColor='#000000' cellSpacing='0' cellPadding='0' " +
          "style='font-size:10.0pt; font-family:Calibri; background:white;width:100%'>");

        HttpContext.Current.Response.Write("

");

        //am getting my Datatable column headers
        int columnscount = dthdr.Columns.Count;

        for (int j = 0; j < columnscount; j++)  // DATATABLE COLUMN NAME
        {      //write in new column
            HttpContext.Current.Response.Write("

");
        }

        HttpContext.Current.Response.Write("

");
        foreach (DataRow dts in dthdr.Rows)
        {//write in new row

            HttpContext.Current.Response.Write("

");
            for (int i = 0; i < dthdr.Columns.Count; i++)// DATATABLE COLUMN VALUE
            {
                //string Data = dt[i].ToString();
                HttpContext.Current.Response.Write("");
            }

            HttpContext.Current.Response.Write("

");

        }
        HttpContext.Current.Response.Write("

//Get column headers  and make it as bold in excel columns             HttpContext.Current.Response.Write("");             HttpContext.Current.Response.Write(dthdr.Columns[j].ColumnName.ToString().Contains("Column") ? "" : dthdr.Columns[j].ColumnName.ToString());             HttpContext.Current.Response.Write("");             HttpContext.Current.Response.Write("

");                 HttpContext.Current.Response.Write(dts[i].ToString());                 HttpContext.Current.Response.Write("

");
        HttpContext.Current.Response.Write("");

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);
        chart.RenderControl(hw);
        string src = Regex.Match(sw.ToString(), "", RegexOptions.IgnoreCase).Groups[1].Value;
        string img = string.Format("", Request.Url.GetLeftPart(UriPartial.Authority), src);
        Table table = new Table();
        TableRow row = new TableRow();
        row.Cells.Add(new TableCell());
        row.Cells[0].Width = 200;
        row.Cells[0].HorizontalAlign = HorizontalAlign.Center;
        row.Cells[0].Controls.Add(new Label { Text = "", ForeColor = Color.Red });

        table.Rows.Add(row);
        row = new TableRow();
        row.Cells.Add(new TableCell());
        row.Cells[0].Controls.Add(new Literal { Text = img });
        table.Rows.Add(row);
        sw = new StringWriter();
        hw = new HtmlTextWriter(sw);

      
        table.RenderControl(hw);
        Response.Write(sw.ToString());
        //
  
        Response.Flush();
        Response.End();

Hi

To export a graph along with GridView data to Excel in ASP.NET, you can utilize libraries like EPPlus or ClosedXML to generate Excel files. First, create your graph using a charting library like Chart.js or Google Charts. Then, populate your GridView with the required data. Finally, combine the graph image and GridView data into a single Excel file.

Here's a simplified example using EPPlus:

// Generate the Excel file
using (var package = new ExcelPackage())
{
    var worksheet = package.Workbook.Worksheets.Add("Sheet1");

    // Add the graph image to the Excel file
    var chart = worksheet.Drawings.AddChart("Chart", eChartType.ColumnClustered);
    chart.SetPosition(1, 0, 1, 0);
    chart.SetSize(800, 400);
    chart.SetTitle("Sample Chart");

    // Add GridView data to Excel
    for (int i = 0; i < gridView.Rows.Count; i++)
    {
        for (int j = 0; j < gridView.Columns.Count; j++)
        {
            worksheet.Cells[i + 2, j + 1].Value = gridView.Rows[i].Cells[j].Text;
        }
    }

    // Save the Excel file
    byte[] fileBytes = package.GetAsByteArray();
    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
    Response.AddHeader("content-disposition", "attachment; filename=GraphWithData.xlsx");
    Response.BinaryWrite(fileBytes);
    Response.End();
}