Forum Discussion

BMD's avatar
BMD
Contributor
10 years ago

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
HKosova
SmartBear Alumni (Retired)

You probably need to change

DDT.ExcelDriver((PathFileName), "Sheet1");

to

DDT.ExcelDriver((PathFileName), "Sheet1", true);

in order to use .xlsx instead of .xls.

sbeach's avatar
sbeach
Contributor
9 years ago

WOW this is tough.

 

It's simply not working.

It stops at the first line.

I downloaded the MS driver and have it setup like this:

 

DDT.ExcelDriver("C:\\BillableAPIUsageReport.xlsx","BillableAPIUsageReport",true)
while (! DDT.CurrentDriver.EOF())
{
//Gets a value from the storage and posts it to the log
Log.Message(DDT.CurrentDriver.Value(0));
DDT.CurrentDriver.Next();
}

// Closes the driver
DDT.CloseDriver(DDT.CurrentDriver.Name);

 

The error i get is:

There was an error on this page.Error description: External table is not in the expected format 14:38:03 Normal

 

This works: DDT.ExcelDriver("C:\\BillableAPIUsageReport.xls","BillableAPIUsageReport",true)

 

I've downloaded the driver, ran as admin.

Restarted pc

Had TC closed when i installed.

Version 11.20.1491.7

 

Is anyone having any luck with xlsx and can 'show me the way' please?


Thanks

Steph Beach

Certica Solutions.

  • djadhav's avatar
    djadhav
    Regular Contributor
    9 years ago

    This is one workaround. If you keep the .xlsx file open while running the tests it should run fine.

    Worked for me. Check if it works for you as well.

    • sbeach's avatar
      sbeach
      Contributor
      9 years ago

      Thank you for your help.

      That did work.

      Then I decided to see if I could get it to fail again so i closed the xlsx file.

      It still worked.

       

      The only thing I did differently was to allow a new windows update this morning and that did a full restart.

      So for anyone else, if you are in my situation, try a full power off and on.

      Who knows with Microsoft.