Hi Team,
While exporting the UltraWebGrid to excel through UltraWebGridExcelExporter we are not able to fix the width. We need an option for autowarp.
Let me explain the issue in detail
Below is the grid which we have exported. Here in grid the second column “Prod.Desc” and third column “Product Type” is the one which is creating problem. In Initiallayout event we have fixed the column width and fieldlen to 150 pixcel. In grid, We are able to see the width what we have defined but while exporting, second column have increased in width in excel. What we thought was based upon the description in the column, width is being increased/adjusted.
Now what we want is to make the width fixed irrespective of column text description.
Thanks in advance.
Regards
Paul
Hi Paul,
Thank you for posting in the community.
I suggest that you take a look at the following discussion on the subject of autowrapping/setting the size of columns in the exported excel sheet:
http://blogs.infragistics.com/forums/p/58967/301248.aspx
Please let me know if this helps.
Hi Petar,
Thanks for your reply. The post was really useful.
Will modify the code and let you know the results.
Thanks once again.
Thank you for your reply.
Please do not hesitate to contact me if any questions arise.