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 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 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.
Have you set the range as empty like “” or leave it as blank
Thanks
Ashwin S
Hi AshwinS2,
below image is the proof that i have set it to as “Blank”.
Hi @SOURAV_KUMAR_DAS
are you able to print the records based on row wise like row(“Column1”).ToString
Thanks
Ashwin S
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
Hi AshwinS2,
Sorry it’s confidential.
Hi
kindly disable the ADD HEADERS property and try once
Cheers @SOURAV_KUMAR_DAS
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.
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
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
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
hm…is the right sheet and excel referred kindly check that once
Cheers @SOURAV_KUMAR_DAS
Hi Palaniyappan Sir,
You got it Correct sir. Thanks you SIr.