是否可以将 SSRS 报告导出到 Excel，并将报告的图表作为 Excel 图表而不是图像？
我在 SSRS 2008 R2 报告中有一个简单的条形图，该报告是使用 ASP.NET AJAX 应用程序中的 VS2008 ReportViewer 控件呈现的。默认情况下，当报表导出到 Excel 时，图表在 Excel 中显示为图像。是否可以将图表呈现为实际的 Excel 图表，而不是图像？
我的最终目标是将图表以可编辑的格式导入 Excel。如果可能的话，我试图避免以编程方式构建 Excel 工作表。
任何可能的方法或信息将不胜感激。
谢谢， 汤姆
I have a simple bar chart in an SSRS 2008 R2 report which is rendered using the VS2008 ReportViewer control in my ASP.NET AJAX application. By default, when the report is exported to Excel, the chart is represented in Excel as an image. Is it possible to have the chart rendered as an actual Excel chart, not an image?
My ultimate goal here is to get the chart into Excel in an editable format. I'm trying to avoid building the Excel sheet programmatically, if possible.
Any possible approaches or info would be greatly appreciated.
Thanks,
Tom
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
目前还不可能。您需要考虑第三方选项。
查看 Office Writer 作为第三方的可能性。不幸的是，它并不便宜。
您也许可以考虑导出实际数据而不是图表的可能性。用户将仅导出数据（这并不是真正需要的），然后他们需要自己创建图表。通过更多的时间和精力，您可以编写一个 Office VSTO 加载项，为最终用户自动化该过程。
最终，如果您正在寻找一种快速、简单且便宜的解决方案，那么仅使用本机 SSRS 导出将是不走运的。
It is not currently possible. You'll need to look at a third-party option.
Take a look at Office Writer as a third-party possibility. Unfortunately, it is not cheap.
You might be able to look at a possibility where you export the actual data instead of a chart. The user would export only the data (which isn't really desired) and then they would need to create the chart themselves. With more time and effort, you could write an Office VSTO Add-In that could automate the process for your endusers.
Ultimately, if you're looking for a quick and easy and cheap solution then you're out of luck with using only the native SSRS export.