Forum Discussion

nb_autoTester's avatar
nb_autoTester
Occasional Contributor
9 years ago

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
    9 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
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
    9 years ago

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