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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2024 09:47 PM
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.
Thanks in Advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2024 10:12 PM
@Sujitha2 - Can you confirm if your excel has data in sheet 1 and Column headers in row 1.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2024 10:54 PM
Yes @Abhit it has data on the Sheet 1 and Column Headers in row 1. Still unable to match it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2024 11:02 PM - edited 04-24-2024 11:05 PM
@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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2024 11:05 PM