Hi,
I have a requirement in my asp.net application to export the asp.net chart generated in the UI to be exported as such to a excel sheet.Not data i need to export as a pictorial graph.
If i use Microsoft.Interop.dll to export excel i am able to achieve but the problem is each time when it is exported it has to be saved in server location and then have to open it.
In my scenario there will be 100+ users will be accessing the application so for each users click to export a multiple excel version will be saved in a server path, it will increase the space in server.
so i went with another approach using Response.Write(strinwriter.tostring()).Here when i export the excel chart is exported to excel but when the same excel is shared to someone through mail.Chart is not available in the excel sheet
Anybody please help on this.
Thanks!...
stringwriter oSw=new Stringwriter();HtmlTextWriter oHw=new HtmlTextWriter(oSw);
Chart.RenderControl(oHw);Response.write(oSw.ToString());