cancel
Showing results for 
Search instead for 
Did you mean: 

External table is not in the expected format.. Was working before, now it's not.

SOLVED
nb_autoTester
Occasional Contributor

External table is not in the expected format.. Was working before, now it's not.

I'm trying to look at two .iif files for comparison of their data. The following lines of code are throwing an error for me:

 

  'Get the two files we need. We will use the original file to verify the data in the exported file
  Set exported_file = DDT.ExcelDriver("J:\Enterprise\A_09170888_01-06.iif", "A_09170888_01-06", True)
  exported_file.Name = "exported_file"
  Set expo_driver = DDT.DriverByName("exported_file")
  
  Set original_file = DDT.ExcelDriver("J:\Enterprise\A_09170888_11-25.iif", "A_09170888_11-25", True) 
  original_file.Name = "original_file"
  Set orig_driver = DDT.DriverByName("original_file")

The error gets thrown on the Set.

 

"External table is not in the expected format."

 

The strange thing is that this was working for me previously and nothing has changed with the two files I'm using. I can go back through my Test Logs and see the successful runs of it working. Does anyone have any idea what could be the problem here? I've also tried restarting Test Complete and that didn't do it.

 

1 ACCEPTED SOLUTION

Accepted Solutions
djadhav
Regular Contributor

Re: External table is not in the expected format.. Was working before, now it's not.

I had faced similar issues with Excel 2013 files. One workaround I found is to open the file before running any reading commands.

View solution in original post

4 REPLIES 4
djadhav
Regular Contributor

Re: External table is not in the expected format.. Was working before, now it's not.

I had faced similar issues with Excel 2013 files. One workaround I found is to open the file before running any reading commands.

View solution in original post

nb_autoTester
Occasional Contributor

Re: External table is not in the expected format.. Was working before, now it's not.


@djadhav wrote:

I had faced similar issues with Excel 2013 files. One workaround I found is to open the file before running any reading commands.


@djadhav Thanks for the response. What method did you use to open?

djadhav
Regular Contributor

Re: External table is not in the expected format.. Was working before, now it's not.

Here is some information with script examples as well.

 

https://support.smartbear.com/viewarticle/69443/

nb_autoTester
Occasional Contributor

Re: External table is not in the expected format.. Was working before, now it's not.

@djadhav You were correct that I needed to open the Excel file before hand, thank you very much for your help!

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors