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

[shekhawat.arjun1307]

Hi All,

I am downloading an excel file from SAP and it always gets downloaded in a way that the first row is empty and the first 2 columns are also empty like shown below:

I want to remove the first row and the first 2 column from this file so that it looks like below:

Attached is the file
Book1.xlsx (10.4 KB)

Thanks

[ppr (Peter Preuss)]

give a try on using a read range with range info: C2
the resulting datatable should be as expected and could used for rewriting to an excel

[shekhawat.arjun1307]

This does the trick, But I need one more help the file format for me is .XLS and when I apply read range activity to this format is get this error : Read Range: Your stream was neither an OLE2 stream, nor an OOXML stream.

Also I forgot to mention the file has 1st row empty like below which I want to remove :

Thanks

[Palaniyappan (Forum Leader)]

@shekhawat.arjun1307

Read Range:

Hi

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

Activities - Remove Data Row

Where mention in property panel like

Datatable- dt
Rowindex - 0

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

Cheers @shekhawat.arjun1307

[jack.chan]

use excel application scope with “insert/delete columns” and “insert/delete rows” activity.
make sure ChangeMode = “Remove”

[Nam_Pham]

EXAMPLE.xaml (8.0 KB)

Very simple, try this !