I am using UltraWebGridExcelExporter and passing in a UltraWebGrid. I setup the columns widths up-front, for example:
The problem I am having is some of the text going into the columns is larger than the percentage defined above as the widths. What happens is the exported excel worksheet widths get auto-expanded to fit the text. I don't want this behavior though as the entire column becomes huge for one record with really long text. I want the width defined fixed as they are defined above, without auto-expansion. Is this possible? Is there a property to accomplish this?
Specify the column widths in the EndExport event handler. If you do it earlier, the values you specify get over-ridden during the row and column exports.