Try below things and see if that works
- Check that the file does not have any hidden rows or columns, it can cause this error
- Try using workbook read range activity to read.
- Select all the empty cells for example you have data till A200 then select all the rows from A201 till last of excel and perform CTRL + - this will delete the rows the reason for this is sometimes excel contains junk data which is not visible but the UiPath identifies it.
First use kill process “Excel”
Before working on any excel from uipath to make sure there are no ongoing excel tasks
If issue still persist use work book activities
here the file :
EXCEL1.xlsx (10.4 KB)
Can u try reading with workbook @Soudios
how can i do that ?
Looking you excel I saw that there are same name columns in the excel file which is causing the error.
In activities search workbook , so once you search , there will be read range workbook --drag that activity and provide your excel path
i just change the column name but there is no same column name in mine
So can u try workbook activities
Yes there select readrange
Try like this
@Soudios follow this
activities search workbook , so once you search , there will be read range workbook --drag that activity and provide your excel path
This works similar to excel application scope readrange
Thank you its working well
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.