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...
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
You probably need to change
DDT.ExcelDriver((PathFileName), "Sheet1");
to
DDT.ExcelDriver((PathFileName), "Sheet1", true);
in order to use .xlsx instead of .xls.
