Please try with Excel Open Action→ Sheet Contains Header--enable

Hi venkythogati8270,

When we are working with excel actions especially when Header is enabled, it is very crucial to understand the excel header.

1. Please check is there any hidden columns in excel file where header is empty.
2. Please check the header names and confirm there are no duplicate names.
3. If still you face the same issue, try to automate without header by using column indexes.

It would be great if you can share the excel header snippet making the sensitive values as blur. so that it will be easy to provide the solution.

Thanks,

Hemantha Pindra

Sir,

I am getting same error.

I checked multiple times. No Duplicate header name or Empty header cell in my excel.

Is it because, after last column, the NEXT column(Say column: C), BOT is taking this as a column header with empty value ?

If this is the case, then how to fix it ?

Hi ​@bubunyellow,

If you have doubt that bot is taking C column as header even there is no column value, try to delete few more columns by selecting the columns and deleting the structure of those columns.

When we just delete the data from excel cells, it will not delete the structure of the columns.

The below snippet will help you to delete the structure of the columns.

Please give it a try and let me know.

Thank you.

HI Mam,

Good Day to you.

Excellent…..

As per your suggestion, I just deleted some empty columns and it worked.

But I am astonished...

Because example: In my above  screesnshot, column-C  does not contain anything. When I deleted Column-C, then again Column C generated .

Then why initialy, BOT was  considering column-C ?