如何使用DataOnlyExcelFormatOptions将水晶报表导出到excel
我正在尝试使用 DataOnlyExcelFormatOptions 选项导出水晶报表。但我卡住了，帮助太丰富而且没有可用的运行示例。
如果我将 ExcelFormatOption 与默认选项一起使用，则列顺序会完全混乱。从 DataOnlyExcelFormatOptions 来看，该属性可能很有趣。但我无法在VB中找到运行的解决方案。
非常感谢任何帮助 谢谢
I'm trying to export a Crystal Report with the DataOnlyExcelFormatOptions option. But I stuck, the help is too pour and no running example available.
If I use the ExcelFormatOption with the default option, the column order is completely messed up. From the DataOnlyExcelFormatOptions, the attribute might be interesting. But I am unable to find a running solution in VB.
any help is truly appreciated
thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我的建议是浏览这些项目 此处。它解决了空白列的问题，但如果您遇到问题，也有一些很好的一般要点可以遵循。
导出时，最好有尽可能稀疏的报告；将其限制为最少的部分，尽可能多地删除格式，并保持字段对齐、对齐到网格且不重叠。您还可以尝试水平分隔字段，并在字段之间留出较大的空间和/或尝试使用固定宽度的列。
如果你有关于“完全搞砸”的具体细节，这将有助于确定其他一些可以尝试的事情。屏幕截图也很有帮助。
My advice is to go through the items here. It addresses blank columns, but has some good general points to follow if you're having trouble.
When exporting, it's best to have the most sparse report possible; limit it to the fewest sections, remove as much formatting as you can, and keep the fields lined up, snapped to a grid, and not overlapping. You can also try separating the fields out horizontally with large spaces in between and/or trying a fixed width column.
If you have specific details about what it means to be "completely messed up," that would help nail down some other things to try. Screenshots are helpful too.