I am exporting to excel, currently, I'm doing this on the grid:

e.Layout.Bands(0).UseRowLayout = True

 By doing this, I unfortunately get a big fat filter row, and all rows are that fat - but when I export to excel, the cells that contain a lot of text are fat, and word-wrapped - to a point.

The problem is two-fold. First of all, I'd like to get rid of this so the filter line is skinny and each line is only as fat as it needs to be (i.e. driven by the size of the text field in question). Secondly, the only way I can get every text cell in excel to be as big as the largest text item I'm exporting is to set the drawing size y value to some huge number. What I want is for each cell to populate and wrap as needed. This works in the grid if I get rid of the line above entirely, but then when I export, each line is only one-line thick - the nice fat word-wrapped cells are gone. I have to manually do it: select all, then click on a grid line, which re-sizes everyone to the size needed - but I'd like to do this programmatically when I export.

Thanks.