VB.NET ReportViewer:导出到 Excel 时合并列
我在 VB.NET 中使用报表查看器。
当用户将报表导出到 Excel 时,某些列会被合并并隐藏。有可能解决这个问题吗?
也许通过操纵某些代码或某处的设置..?
I'm using a reportviewer in VB.NET.
When the user exports a report to Excel some of the columns get merged and hidden. is it possible to fix this?
Maybe by manipulating some code or a setting somewhere..?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
Excel 以磅为单位测量列,报表查看器将允许您以英寸、磅等为单位进行测量。如果您在报告中使用 in. 作为列宽,请尝试调整列宽,以便它们在转换为磅时不会出现任何舍入问题。这对我有用。
转换 = 72 点/英寸。所以 0.875 英寸可以转换为 63 点。 Excel 会对此感到高兴。
这是一个转换计算器:http://dx.sheridan.com/advisor/converter.html
Excel measures columns in pts, Report Viewer will let you measure in inches, pts, etc. If you are using in. in the report for your column widths try adjusting your column widths so that they convert without any rounding issues to pts. This worked for me.
Conversion = 72 pts/inch. So 0.875 inch would convert to a nice even 63 points. Excel will be happy with that.
Here is a conversion calculator: http://dx.sheridan.com/advisor/converter.html