如何从 .rdl 报告生成平面 Excel 文件？
我有一个 .rdl 报告，将数据格式化为报告。我想将该数据导出为 Excel 平面表格，其中包含根据报告中的参数返回的原始数据。默认的 Excel 导出看起来就像报告一样，这不是我想要的（我只想要行和列）。有没有简单的方法可以做到这一点？
I have a .rdl report that formats data as a report. I want to export that data to excel as a flat table with the raw data that was returned based on the params in the report. The default excel export looks just like the report which isn't what I want (I just want rows and columns). Is there an easy way to do this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以将其另存为 csv 文件。之后，您必须在 Excel 中导入该文件，而不是用 Excel 打开该文件。
You can save it as csv file. After that you must import that file in excel not open that with excel.
如果您想将其作为非 CSV 格式，请确保任何报告的格式为零，并尝试确保所有字段都转换为其类型 - 有时 excel 会错误估计日期等，请使用 .net 转换函数来执行此操作 - 或者您可能必须破解字段的数据集数据类型。
删除任何页眉、页脚、图表 - 您基本上是在尽可能简单地进行操作。
如果您确实包含其中任何一个，请确保它们的起点和终点对齐，如果没有，那么您将得到拆分单元格。
If you want to do it as a non-CSV format then make sure that you have zero formatting on any of the report and also try and make sure that any fields are converted into their type - sometimes excel misunderestimates dates etc, Use .net convert functions to do this - alternatively you may have to hack the dataset datatype for a field.
Remove any headers, footers, charts - you're basically after as vanilla as possible
If you do include any of these, make sure they start and finish points line up, if not then you'll get split cells.