The excel worksheet contains any/all of the following: - Empty header(s) - Duplicate header name(s) - Invalid cell ranges. i am facing this issue after run the bot.give me solution so many times its came this error.
Solved
excel Header Issues
Best answer by HemanthaPindra
Hi venkythogati8270,
When we are working with excel actions especially when Header is enabled, it is very crucial to understand the excel header.
- Please check is there any hidden columns in excel file where header is empty.
- Please check the header names and confirm there are no duplicate names.
- 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
+16- Most Valuable Pathfinder
- 3274 replies
Please try with Excel Open Action→ Sheet Contains Header--enable
+5Hi venkythogati8270,
When we are working with excel actions especially when Header is enabled, it is very crucial to understand the excel header.
- Please check is there any hidden columns in excel file where header is empty.
- Please check the header names and confirm there are no duplicate names.
- 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
+3Sir,
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 ?
+5Hi
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.
Hemantha - RPA Developer/Consultant. Contact me over LinkedIn (https://www.linkedin.com/in/hemantha-pindra-5a4041216/)
1 person likes this
+3HI 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 ?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.