I want to know the row number for the array of strings


#1

Hi Developers,
I have a problem with the row number of the particular string , (row count is not exactly giving the info i needed help me out of this )

*****In the code (.xaml) file u can see the “row_count.tostring” i am getting the output as “1” but i need the “item” rowcount ****
I have a excel data in which i need to read particular array of strings row numbermar29_last_day.xaml (14.4 KB)
mar28.xlsx (8.8 KB)
in the form of strings , please find the attachment and the .xaml file for the reference

@arivu pls help me with the solution


#2

HI @lalithya14,

Use this
mar29_last_day.xaml (14.3 KB)

Regards,
Arivu


#3

i am getting the output as :
Downloads execution started
PF FULL TL - AGENCY
1
ATP
2
ATP
2
ACR
3
Letter of Counter Offer
4
ACR
3
ATP
2
Downloads execution ended in: 00:01:08

My desired solution is their corresponding row number as in the excel .
suppose, PF FULL TL - AGENCY is in row no 3 in excel so, i want that number
my output needs to be :-

PF FULL TL - AGENCY
3
ATP
5
ATP
7
ACR
8
Letter of Counter Offer
10
ACR
14
ATP
15

i am unable to find the solution help me arivu


#4

HI @lalithya14,

mar29_last_day.xaml (15.3 KB)

Regards,
Arivu


#5

i am getting an error , as please find the screenshot of that errorCapture


#6

image

i am getting output please check it


#7

its working fine …:smiley::smiley: