Error while retrieving data from Excel

Hi All,

I am unable to retrieve the second data and so on from excel sheet and place it in website where as the first data is fetched and processed.

image

If there’s a solution please let me know it as soon as possible.

@SOURAV_KUMAR_DAS,

How you are reading the data from this excel, and are you using any framework mechanism to process the data.

I recommend you to use RE Framework for Tabular data, which will handle move to the next record if first one is completed.

1 Like

Hi @SOURAV_KUMAR_DAS,
Are you getting any error while processing?

Cheers.
Vashisht.

1 Like

Hi Vashisht Sir,

Yes Sir… I am getting error.

Hi sarathi125 Sir,

No Sir…normal I am using

What error you are getting?
And also give more details how you are entering excel data into website!!!

Regards,
Karthik Byggari

2 Likes

Hi KarthikByggari Sir,

Is there any solution let me know…

Can you please elaborate your process. What you are trying to do?

1 Like

Hi KarthikByggari Sir,

Can You share me your mail Id Sir…

Check your inbox.

1 Like

Hi Sir,

I have sent you a mail Sir.

Hi KarthikByggari Sir,

Is there any solution based upon my requirement and with sample Xaml files…

I will check. I got busy with other important work. I will let you know soon.

1 Like

Hi KarthikByggari Sir,

Ok Sir.

Hi KarthikByggari Sir,

Any progress…?

I will check now and let you know.

1 Like

Hi KarthikByggari Sir,

Ok Sir.

HI @SOURAV_KUMAR_DAS,

I think you are using read range activity with range “A1” and “B1” and so on which makes it to read only one row.
if you change it to “A1:A+“dtYourExcelRead.rows.count.ToString”” or “B1:B+”+dtYourExcelRead.rows.count.tostring+"" , you will be able to read all the rows.

you can also use Nothing to read all the columns at the same time.

Hope this will work for you.

Thanks!

1 Like

Hi Deepak94 Sir,

I can’t get it out your reply.

Hi @SOURAV_KUMAR_DAS
Ok.
Try to replace “A1” with “” and “B1” with “” and so on in read range activity.
I know you are reading one column at a time but, above method should not make any impact on your current process.
There is another way as well to read all the columns in single for each but you try above one and please let me know if its working or not.

Thanks!

1 Like