Not able to populate more than 256 charactes in a singel cell of Excel thru QTP 10.0

[surbhit4u]

Hi,

I am using QTP 10.00 & MS Office 2007

For some of my business scenarios, for one of the column in excel, I want to populate more than 500 charactes in a single cell.

However, when I try to populate the data through QTP, the data truncates to 256 characters.
I even tried after enabling Wrap Text in the XLS, but still got the same result.
If I populate the data by just copy-paste i.e. without QTP, then XLS allows even 10,000 characters to be stored in single cell.

Can you please help me how can I achieve the populatation of more than 500 characters through QTP.

Thanks in advance

Regards
Surbhit