Delete Row activity error

Help Activities
, ,
1

Hello,

I have an assign activity which gives me a row index of variable integer type:

image
image996×188 37 KB

I would like to put this number into a delete rows activity like this:

image
image801×607 22.8 KB

However I am getting the error:

image

Please advise cheers

2

Hi,

How about intRowIndex+1 or intRowIndex+2 because IndexOf returns 0-based index

Regards,

3

This works thank you!

I am having some issues however configuring the activity.

I have data in an Excel like this:

image
image1403×496 7.75 KB

The row index starts in row 1 but my data starts at row 6 - I would like the row index to start from row 6

This is causing an issue with my delete row activity as the incorrect row is being deleted

Was wondering how I can configure the activity so that the row index starts at row 6?

Cheers

4

Hi,

How about intRowIndex+7 ?

Regards,

5

Hi,

I have tried that however when a row is deleted then the +7 is not accurate. Also the deleted row could be above or below the row I want to delete therefore unsure how to configure

6

HI,

Can you share your workflow and xlsx file, if possible?

Regards,