Forum Discussion

nb_autoTester's avatar
nb_autoTester
Occasional Contributor
10 years ago
Solved

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 ...
  • djadhav's avatar
    djadhav
    10 years ago

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

nb_autoTester's avatar
nb_autoTester
Occasional Contributor
10 years ago
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?

  • nb_autoTester's avatar
    nb_autoTester
    Occasional Contributor
    10 years ago

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