Removing the first row and first 2 columns from an excel file


Hope the below steps would help you resolve this

  1. To read .xls file always use EXCEL activity where use a excel application scope and pass the file path as input

  2. Inside the scope use a READ RANGE activity and there mention the range like this “C2” and get the output as dt

  3. If you are facing issue again then try upgrading the excel package
    Go to Design tab → Manage Packages → Project Dependencies → Upgrade UiPath.Excel.Activities

  4. Now to remove that empty row use this activity
    Remove Datarow activity

Where mention in property panel like

Datatable- dt
Rowindex - 0

  1. Now use a WRITE RANGE activity and then pass dt as input and enable add headers property

Cheers @shekhawat.arjun1307

1 Like