Hi
Hope the below steps would help you resolve this
-
To read .xls file always use EXCEL activity where use a excel application scope and pass the file path as input
-
Inside the scope use a READ RANGE activity and there mention the range like this “C2” and get the output as dt
-
If you are facing issue again then try upgrading the excel package
Go to Design tab → Manage Packages → Project Dependencies → Upgrade UiPath.Excel.Activities -
Now to remove that empty row use this activity
Remove Datarow activity
Where mention in property panel like
Datatable- dt
Rowindex - 0
- Now use a WRITE RANGE activity and then pass dt as input and enable add headers property
Cheers @shekhawat.arjun1307