How to loop in For Each row?

Help
, , ,
1

Hi All,

I have a question that I am unable to loop the for each row in Sequence to get another record.

So is there a solution please let me know it as soon as possible.

2

Hi @SOURAV_KUMAR_DAS

Can you explain the requirement clearly please

Thanks
Ashwin S

1 Like
3

Hi AshwinS2,

I have an excel sheet where it has 3 records in which i am using read range to read the excel data’s and passing it to for each row activity where it only scans it out only one record.

4

Hi @SOURAV_KUMAR_DAS

Have you set the range as empty like “” or leave it as blank

Thanks
Ashwin S

1 Like
5

Hi AshwinS2,

below image is the proof that i have set it to as “Blank”.

image

6

Hi @SOURAV_KUMAR_DAS
are you able to print the records based on row wise like row(“Column1”).ToString

Thanks
Ashwin S

1 Like
7

Hi AshwinS2,

Yes I could process the records, but not fetching out the second record.

8

Hi @SOURAV_KUMAR_DAS
can you share your excel

Thanks
Ashwin S

1 Like
9

Hi AshwinS2,

Sorry it’s confidential.

10

Hi
kindly disable the ADD HEADERS property and try once
Cheers @SOURAV_KUMAR_DAS

1 Like
11

Use OutputDataTable activity and give a string type variable example “testoutput” in output. Then use writeline to print output of this “testouput”. check whether your entire data is printed correctly or not. This may be a way to check ur datatable first and then look for next actions.

1 Like
12

Hi Palaniyappan Sir,

It’s throwing error when I remove the ADD Headers property.

13

May i know what was the error we are getting
and also how many rows are there in the excel and is the first line of excel is a header
if so we can keep add headers enabled or else we can disable and that would work buddy

Cheers @SOURAV_KUMAR_DAS

1 Like
14

Hi Palaniyappan Sir,

The first line of Excel Sheet is a header. and kept as enabled.

15

hmm…then as we have only two records where the first one is a header obviously we will be getting only one record when looped

kindly correct me if i have understood the query wrongly
Cheers @SOURAV_KUMAR_DAS

1 Like
16

Hi Palaniyappan Sir,

There is a header and two records Sir and totally of 3

17

Fine use a writeline activity and mention like this
datatable.Rows.Count.ToString
lets see what is the value coming

Cheers @SOURAV_KUMAR_DAS

1 Like
18

Hi Palaniyappan Sir,

Only one Sir.

image
image1279Ă—299 7.87 KB

19

hm…is the right sheet and excel referred kindly check that once

Cheers @SOURAV_KUMAR_DAS

1 Like
20

Hi Palaniyappan Sir,

You got it Correct sir. Thanks you SIr.

1 Like