How to loop in For Each row?

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.

Hi @SOURAV_KUMAR_DAS

Can you explain the requirement clearly please

Thanks
Ashwin S

1 Like

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.

Hi @SOURAV_KUMAR_DAS

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

Thanks
Ashwin S

1 Like

Hi AshwinS2,

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

image

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

Thanks
Ashwin S

1 Like

Hi AshwinS2,

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

Hi @SOURAV_KUMAR_DAS
can you share your excel

Thanks
Ashwin S

1 Like

Hi AshwinS2,

Sorry it’s confidential.

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

1 Like

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

Hi Palaniyappan Sir,

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

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

Hi Palaniyappan Sir,

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

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

Hi Palaniyappan Sir,

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

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

Hi Palaniyappan Sir,

Only one Sir.

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

Cheers @SOURAV_KUMAR_DAS

1 Like

Hi Palaniyappan Sir,

You got it Correct sir. Thanks you SIr.

1 Like