Unable to load headers. Please verify that the specified sheet number is valid - Data Source Import

Sujitha2
Mega Guru

Hi,

I was trying to import an Excel sheet using Inbound Email action. While loading the excel sheet on the scheduled import step, It throws an error - "Unable to load headers. Please verify that the specified sheet number is valid". But If I copy the contents of the same excel sheet that came from email into into a different new excel file and load it then it loads perfectly and processes the data. 

 

Not sure what is the difference between the excel that comes from email through an external system vs the excel which was saved locally on the system.

 

Can someone help me understand the difference, also if any scheduled/data source properties needs to be set. 

Sujitha2_0-1714020375879.png

 

Thanks in Advance.

 

8 REPLIES 8

Abhit
Tera Guru

@Sujitha2 - Can you confirm if your excel has data in sheet 1 and Column headers in row 1.

Yes @Abhit it has data on the Sheet 1 and Column Headers in row 1. Still unable to match it.

Abhit
Tera Guru

@Sujitha2  can you paste the image of the file with just the header or remove the unwanted space from column header and retry it. make sure the row1 is not hidden.

Sujitha2
Mega Guru

Please find below snippet. @Abhit 

Sujitha2_1-1714025087212.png