Anyone knows how to make the format in exported excel file as the same as you
defined in report? My problem is the cell does not grow as content grow even
though I have set textbox cangrow property as true.

I think it's a bug in excel rendering extension. The only workaround I know
is to make your cell fit into exactly one excel column. (if you select this
cell you will notice that it belongs to multiple columns in Excel). To
achieve this you have redesign your report a little bit to remove all the
"intersections" this cell has with the other data regions (textboxes etc.)
that is placed somewhere else in your report. In my case I had a small
textbox in my report header and because of this my table cell mapped into 3
excel columns.

[quoted text, click to view]