BMD
11 years agoContributor
DDT.ExcelDriver for .xlsx not .xls
 Team,  The function below worked until I changed the format from .xls to .xlsx.  Now the log returns "  External table is not in the expected format".  Is there are way to correct this.  I did not th...
- 11 years ago
Hello BMD,
You may need to download the Microsoft Office data connectivity driver to access the newer XLSX format.
2007 Office System Driver: Data Connectivity Components
More details on this in the TestComplete help here:
Using Excel Files as Data Storages
-Dan
 - 11 years ago
You probably need to change
DDT.ExcelDriver((PathFileName), "Sheet1");
to
DDT.ExcelDriver((PathFileName), "Sheet1", true);
in order to use .xlsx instead of .xls.