Delete Rows Excel Activity. This should be simple but its not

[Waterfowl_Waterfowl_hunte (Waterfowl Waterfowl hunter)]

Why is the “At Position” is not working? this should be simple.

I entered the row exactly as the example shows below. this makes no sense.

I even tried creating and using a int32 variable

[ashokkarale]

@Waterfowl_Waterfowl_hunte,

Try “1” as it’s expecting string. Integer will not work in case of range we need to pass.

Thanks,
Ashok

[rlgandu (Rajyalakshmi Gandu)]

@Waterfowl_Waterfowl_hunte

If you want to delete more than 1 row

[mkankatala (Mahesh Kankatala)]

Hi @Waterfowl_Waterfowl_hunte

At position field in Delete rows activity will accept only String datatype variables. If you are passing a variable to it the variable datatype should be System.String.

Or you can give the direct position value with in double quotes as below, They specified that it will accept string datatype for the At Position Field,

Hope it helps!!

[Waterfowl_Waterfowl_hunte (Waterfowl Waterfowl hunter)]

Thank you All! adding quotes worked!

[ashokkarale]

@Waterfowl_Waterfowl_hunte,

Wonderful! Kindly close the thread by marking the answer as solution.

Thanks,
Ashok

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @Waterfowl_Waterfowl_hunte

Happy Automation!!