Export Chart Report to Excel with editable chart not image

[zxp]

Hi,

I want to export a chart report to excel. Right now exporting works fine. A new requirement is to edit the chart in the excel. Right now it will export a image for the chart. How can I export real chart, not image to excel? 

Here is my exporting code:
var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("xlsx", report, null);

                string fileName = user_keyid + "_" + project_id + @"\" + Guid.NewGuid().ToString() + "." + extstr;
                if (!System.IO.Directory.Exists(AppDomain.CurrentDomain.BaseDirectory + user_keyid + "_" + project_id))
                {
                    System.IO.Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + user_keyid + "_" + project_id);
                }
                var fs = new System.IO.FileStream(AppDomain.CurrentDomain.BaseDirectory + fileName, System.IO.FileMode.OpenOrCreate);

                fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

                fs.Flush();

                fs.Close();

Any help will be appreciated!

[Steve]

Hello zxp,

The behavior you observe is by design and cannot be changed. Chart report items are rendered as an Excel Picture object and not Excel Chart object. In Microsoft Excel 97-2003 it is a Bitmap image; in Microsoft Excel 2007 and above it is a Metafile. This information is available in the Design Considerations for Excel Rendering help article.

Greetings,
Steve
the Telerik team

[zxp]

Thanks for the quick post. Seems like I have to draw the excel chart myself using the report data source.