Forum Discussion

BMD's avatar
BMD
Contributor
9 years ago
Solved

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...
  • HKosova's avatar
    9 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.