首页 > 代码库 > Sql Server Report 导出到EXCEL 指定行高

Sql Server Report 导出到EXCEL 指定行高

  在SQL SERVER REPORT 2005做报表的时候,发现在report中指定的行高没有用。google了一下,找到了解决方法。

 Make both CanGrow and CanShrink are False for all of the cells in the row.  This is because Excel itself doesn‘t really have a concept of CanGrow and CanShrink - rather, all it can do is 1) keep row heights at a static value (which it will do if both of those properties are False), or 2) "snap to fit".

Sql Server Report 导出到EXCEL 指定行高