DDT.ExcelDriver Sometimes Truncates Long Strings at 255 characters.
Hi
I am using the DDTDriver - to drive my data driven tests using spreadsheet
ie. MainDriver = DDT.ExcelDriver(Path + Workbook, Sheet, true);
I have found, on some of the sheets I hav...
Hi, I think I have found the cause. 😀
I found this section in the documentation:
-
The Excel ODBC driver can truncate cell data to 255 symbols. To determine the data type of a column, Excel scans the column cells of the first 8 rows. If each of these cells contains text shorter than 256 characters, all the subsequent cell values will be truncated to 255 symbols. For more information, see docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/initializing-the-microsoft-excel-driver.
It would explain the behaviour. Adding it so others might also benefit from it. (Simple solution is to include a long string in the first 8 rows of your DDT test, then other rows will not be truncated).
-
