This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
- edited on
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?
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.
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.
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.