Fo each row and sheet

Help Studio
, ,
1

I have a sheet that consists of stores and its codes.and i’m working on a project where i want to write the excel data into an desktop application .during this process,it should select a company and then the relevant sheet from excel file and write to the application .My project is not slecting the next store .It’s just selecting the same company again n again .could someone help me !!!

2

Hi @Rohith_Kumar1 ,
Can you share input and expect output to clear requirements
I understand your excel file have 2 column
image

you want to get each row to process
you can use for each row in data table

regards,

3

@Rohith_Kumar1

can you check the selector of the click actvivity which you are used for typing Company names

make dynamic so that it will click on all the companies

cheers

4

well…can we connect for a while in meet ?
so that i can express query in a better way !!!

5

can i connect u in meet ?

6

now, I’m in vietnam and in working time in company
can you share me about workflow chart,
eg:
image
or image about input and expect output
or we can connect in meeting after 4 hours

7

well…lets connect in meet after 4hours…i’ll wait till then .ping me once you’ve done with your work

8

Ok @Rohith_Kumar1
I will send message to you when comeback home

9

definitely and thanks

1 Like
10

@Rohith_Kumar1

Welcome to the community

So you can follow steps like this

  1. Read the first sheet containing stores and codes into datatable dt
  2. Now use for each row in datatable and give the datatable from step1 dt
  3. Inside loop use currentRow("Stores").ToString to get the stores and I hope that gives you company so can use this as sheet while reading excel
  4. After you get data use one more for loop on the new read table inside the first loop and then inside it use your writing data to application

hope this helps

cheers

11

it’s not working ,
can we connect for a while via meet ??

12

@Rohith_Kumar1

Can you please tell what is not working

cheers

13

it’s running in loop but considering the same store that is present in the first row again and again

14

@Rohith_Kumar1

then you would not have used currentrow

cheers

15

i used …can we connect for while ?