community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Trying to Load an Invalid Excel File

Moderator
Moderator
Created on

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.

Comments
Meteor

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

Alteryx
Alteryx

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.