如何设置 spread 列宽自适应 代码

Question

如题所述

Answer 1

[Visual Basic .NET Code]
Dim s As Single
s = FpSpread1.ActiveSheet.GetPreferredColumnWidth(0)
FpSpread1.ActiveSheet.Columns(0).Width = s + 1

[C# Code]
float s;
s = FpSpread1.ActiveSheet.GetPreferredColumnWidth(0);
FpSpread1.ActiveSheet.Columns(0).Width = s + 1;
具体实现请参考下面的博客http://blog.gcpowertools.com.cn/post/2012/11/12/%E8%87%AA%E5%8A%A8%E8%B0%83%E6%95%B4%E5%88%97%E5%AE%BD%E4%BB%A5%E9%80%82%E5%BA%94%E8%AF%A5%E5%88%97%E4%B8%AD%E6%9C%80%E5%AE%BD%E7%9A%84%E6%96%87%E6%9C%AC-.aspx