Trying to Load an Invalid Excel File

[DanC]

Question

Why am I getting the error "InvalidArgument=Value of '0' is not valid for 'itemIndex'. Parameter name: itemIndex" when trying to load an Excel file in and Input tool?

Answer

This error has come up when an Excel file that had the extension .xls, but was saved as .xlsx, or vice versa. The resolution to this is to save the file with the original extension.

[ClaudiaV]

Hello 

is there another way? In my case I have a batch of 200 files and don't want to open them one by one.

Also, this is how the file came. It is an export from a Facebook report.

Thanks

[CameronS]

Hi @ClaudiaV,

You should be able to tell the input data tool to override the extension and read the file as the extension it should be saved as using Option #2 in the input data configuration properties.  This would allow you to use the wild card input for batch reading the files if they have the same schema or allow you to change one of the batch excel reading macros that are floating around if that is what you are using instead.