将 QuickReport 导出为 Excel xlsx 格式
我们需要导出一个QuickReport,以便可以使用最新的Excel 2010以xlsx格式打开它。 此链接提供了解决方案。但这对我们不起作用。
有人有想法吗?
更新
- 我们使用的版本是 QuickReports 5 - 我们刚刚得到它。
- 澄清“不起作用”。该过滤器允许使用 xml 扩展名保存报告。并检查文件是否是有效的 xml 数据。但我们还检查了一个 xlsx 文件。但看起来并不一样。
We need to export a QuickReport so that it can be opened with the latest Excel 2010 in xlsx format. This link provides a solution. But it did not work for us.
Anyone have ideas?
UPDATE
- The version we are using is QuickReports 5 - We just got it.
- Clarification of "does not work". The filter allows the report to be saved with an xml extension. And inspecting the file it is valid xml data. But we also inspected a xlsx file. But it does not look the same.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
也许是一个愚蠢的问题,但您非常确定需要这样做吗?新版本的 Excel 仍然可以打开旧式的 .XLS 文件。
至于您链接到“不工作”的“XML”导出器,我认为您误解了它的作用。它编写适合与 Excel 的 XML 导入器一起使用的 XML 文件。这与 .XLSX 格式文件非常不同,
Maybe a dumb question, but are you quite sure you need to do this? New versions of Excel can still open old-fashioned .XLS files.
As for the "XML" exporter you linked to "not working", I think you've misunderstood what it does. It writes an XML file suitable for use with Excel's XML importer. This is very different to an .XLSX format file,
您可以尝试第三方产品,例如 Gnostice eDocEngine。它允许您导出到 .xls。如果您感觉特别受虐,您可以执行某种 COM 自动化来自行转换报告(即解析报告并填写 excel 中适当的单元格)
You could try a third party product like Gnostice eDocEngine. It would allow you to export to .xls. If you were feeling particularly masochistic you could do some sort of COM automation to convert the report yourself (i.e. parse the report and fill in the appropriate cells in excel)