SSRS Excel export, Row height not increased in excel

4
votes

In one of my SSRS Report, The cell is expanding properly in report but when the report is exported to Excel the single cell contain the whole text but I have to manually increase the row height in excel to make the whole text visible.

Is there any export option in SSRS where can tell excel to adjust the row height as per the data.

1
reporting-servicesssrs-2012
Just to check, how large is the row? The Excel renderer has a maximum row height of 409 points. - bitnine

1 Answers

1
votes

It depends on what reports layout you have, but generally simply setting CanGrow=True should expand cell in Excel export. Probably you'll need to set CanGrow=True for all cells in the row. This will not work in case you have merged cells in the row.

See more info here.