Excel automation 2

[ldiaz (Leonardo Diaz)]

hi . how can i select a column and start my process from that column
example: i want to start in Column H Row 9 [H9]
like this

[Gokul001 (Gokul Balaji)]

HI @ldiaz

1. Use Read Range activity → Store it as Dt1

Range -> ""

2. Use Read Range activity → Store it as Dt2

Range -> "H9:"+Uipath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(Dt1.Columns.Count)+Dt1.Rows.Count.ToString

Regards
Gokul

[Rahul_Unnikrishnan]

Hello @ldiaz
Here in Excel what operation are you trying to do? Can you please give more clarity on that?

If you are trying to read excel from H9, then you can use the Read Range activity by providing the Range starting from H9.

Thanks

[Marius_Puscasu]

@ldiaz

start my process from that column

Hello @ldiaz ,

One alternative is to use the Read Column activity (link: https://docs.uipath.com/activities/docs/read-column )

It has this property:

StartingCell - The cell from which to start extracting the column data. Only string variables and strings are supported

Hope it helps!
Best regards,
Marius

[ldiaz (Leonardo Diaz)]

i’m trying to read multiple columns. is theres a way to do it without indicating in the read range ?

[ldiaz (Leonardo Diaz)]

i’m trying to read multiple columns. is theres a way to do it without indicating in the read range ?

[ldiaz (Leonardo Diaz)]

i’m trying to read multiple columns. is theres a way to do it without indicating in the read range ?

[ldiaz (Leonardo Diaz)]

i’m trying to read multiple columns. is theres a way to do it without indicating in the read range?

[Rahul_Unnikrishnan]

If you want to read multiple columns, you can use read as below.

Use Read range for the full excel->Then use Filter datatable activtiy->select keep and mention the columns to keep.

Thanks

[Gokul001 (Gokul Balaji)]

Have you tried with above expression ? @ldiaz

It will work as you need.

You can also try to use Filter Data Activity

Regards
Gokul

[ldiaz (Leonardo Diaz)]

nope. i will try this. thanks

[ldiaz (Leonardo Diaz)]

i will try this. thanks

[Gokul001 (Gokul Balaji)]

Okay @ldiaz , Try it and let us know if your are facing issue

[Rahul_Unnikrishnan]

This approach should work for you as you need to retain multiple columns from excel.
Single read range activity and single filter datatable activity.

Thanks

[ldiaz (Leonardo Diaz)]