I'm using a copy data activity to move data from excel files to a db. In the mapping I added the column names that should come in the excel file. Sometimes files come with columns without a name and the activity fails with error:

ErrorCode=ExcelInvalidHeader,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Invalid excel header with empty value.

Is there a way to ignore the columns with no name and keep using the column name's for the mapping? I'm aware that using column numbers could "fix" this issue but I need to use the column's names.