sankar_k
11 years agoOccasional Contributor
Reading data from Excel using DDT
Hi There
I read data from Excel using DDT and it is working fine. I pass one SQL statement from Excel which is more than 350 character length. The statement is not fully read and the string available in TestComplete after reading is only 250 characters and rest is truncated. Could you please let me know is there any restriction in reading number of characters / length of a string from Excel File
Thanks
Sankar K
I read data from Excel using DDT and it is working fine. I pass one SQL statement from Excel which is more than 350 character length. The statement is not fully read and the string available in TestComplete after reading is only 250 characters and rest is truncated. Could you please let me know is there any restriction in reading number of characters / length of a string from Excel File
Thanks
Sankar K
- What version of Excel?
Really old versions (2003 and earlier I think) had a 255 character limit within a cell. Newer ones don't. (Well, they have a limit, but it's thousands of characters.)
It could also be caused by the way the connection is made to Excel by TestComplete. First answer here explains it. Not sure how the TC DDT connection is established:
http://superuser.com/questions/646825/255-max-character-size-in-excel-cell-when-cell-data-is-linked-fetch-from-externa
Personally, I don't like huge strings of text in excel cells. I commonly pass in JSON blobs to my tests. I store them as text files and then store a link to the text file in the Excel data. Much easier to read ....
(Obviously, my framework also has to be smart enough to know it's a file like so I use a prefix to flag it and the framework parses it ...)