Format cells Excel extract index

Help
1

Hello friends,
@rkelchuri, @arivu96, @Rammohan91, @balupad14, @Florent_Salendres, @vvaidya, @Palaniyappan, @loginerror, @MAHESH1, @Manjuts90

image
image1920×1080 269 KB

I need to extract the index of the row in Excel where Column=‘Fornitore’ is 101289
If the format of the row is Text UiPath gives this error:
Indice riga da cancellare: Index was outside the bounds of the array.

If ti change the format toi NUmber, it gives index 0.
Why that? how to fix this problem?
It’s very urgent
Cami :slight_smile:

1 Like
2

Hi
Cami the expression used would actually work but I will simulate at this and let you know but as of now
—hope these steps would help you resolve this
—use a excel application scope and pass the file path as input
—inside the scope use a read range activity and get the output with a variable of type datatable named dt
—next to this read range use a for each row loop and pass the variable dt as input
—inside the loop use a if condition like this
row(“Fornitore”).ToString.Equals(“101289”) AND row(“Note”).ToString.Equals(“your nite value”)
If this matches It will go to THEN part where we can have a writeline like this
dt.Rows.IndexOf(row).ToString
—followed by this writeline use a BREAK activity so that once the first match is found it will come out of the loop

Kindly try this and let know for any queries
Cheers @

3

Thank you so much @Palaniyappan,

i’ll try and let you know.
Cami

1 Like
4

Were we facing any issue in this
Is it working fine
Cheers @CamiCat

5

Hello @Palaniyappan,

i’m finishing to try.
Let you know very very soon.
Cami

1 Like