How Export Graph With Gridview Data Into Export To Excel

Question

Sandeep Kumar · Answer

//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 { //write in new column 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(" "); foreach (DataRow dts in dthdr.Rows) {//write in new row HttpContext.Current.Response.Write(" "); for (int i = 0; i { //string Data = dt[i].ToString(); HttpContext.Current.Response.Write(" "); HttpContext.Current.Response.Write(dts[i].ToString()); HttpContext.Current.Response.Write(" "); } HttpContext.Current.Response.Write(" "); } 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();

Jayraj Chhaya · Answer

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