Wrapping Problem while exporting to excel

Hi Guys,

I have designed a report which works fine in html format. The data appears without any wrapping in html format. But when I export it into excel the data wraps and for bulk data it narrows down considerably. Please note that I have already invested some time on this without any results. So it will be a great help if any of you can help me on this. Is there is any property where we can define nowrap on the data column.

Thanks in advance,
Devidas

Find more posts tagged with

Comments

a3e

Devidas,

I too have some trouble with the layout of the report when export into xls. What I can suggest is to specify whether you'd like to have a landscape or portrait, and then specify the width of each column so that it fit into the size of the paper in the format that you specified.
I do this with trial and error and it's not perfect but the result got pretty close to what i want.

Hope this helps.

Cheers,
Albert

Devidas

Hi Albert,

Thanks for the response. Am trying with setting the custom page width in master layout and seems to be working fine. Am working on this.... Will let you know once I get a cleaner approach.

Thanks,
Devidas