|107582||Mar 7,2013 02:26 PM UTC||Mar 11,2013 12:11 PM UTC||ASP.NET Web Forms (Classic)||1|
Thanks for using Syncfusion products.
We can draw the chart control as bitmap image and add it to the sheet of excel file for your requirements. Since, we don’t have built-in functionality to export the multiple chart to excel. Kindly refer the below code snippet to achieve this,
string exportFileName = "Chart.xls";
//A new workbook with a worksheet is created.
IWorkbook chartBook = ExcelUtils.CreateWorkbook(1);
IWorksheet sheet = chartBook.Worksheets;
int toprow = 4, topcolumn = 5, bottomrow = 20, bottomcolumn = 12;
for (int i = 0; i < 2; i++)
Bitmap img = new Bitmap((int)chart[i].Width.Value, (int)chart[i].Height.Value);
string chartimage = "chartimage" + i + ".Jpg";
sheet.Pictures.AddPicture(toprow, topcolumn, bottomrow, bottomcolumn, img);
topcolumn = bottomcolumn + 3;
bottomcolumn = topcolumn + 7;
//Save the Chart book.
Please refer the attached sample for this requirements and let us know if any concerns.
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.