+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Others (https://www.learnqtp.com/forums/Forum-UFT-QTP-Others)
+--- Thread: Not able to populate more than 256 charactes in a singel cell of Excel thru QTP 10.0 (/Thread-Not-able-to-populate-more-than-256-charactes-in-a-singel-cell-of-Excel-thru-QTP-10-0)
Not able to populate more than 256 charactes in a singel cell of Excel thru QTP 10.0 - surbhit4u - 08-16-2010
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