Error while retrieving data from Excel

Help
, ,
#1

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.

#2

@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
#3

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

Cheers.
Vashisht.

1 Like
#4

Hi Vashisht Sir,

Yes Sir… I am getting error.

#5

Hi sarathi125 Sir,

No Sir…normal I am using

#6

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

Regards,
Karthik Byggari

2 Likes
#8

Hi KarthikByggari Sir,

Is there any solution let me know…

#9

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

1 Like
#10

Hi KarthikByggari Sir,

Can You share me your mail Id Sir…

#11

Check your inbox.

1 Like
#12

Hi Sir,

I have sent you a mail Sir.

#13

Hi KarthikByggari Sir,

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

#14

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

1 Like
#15

Hi KarthikByggari Sir,

Ok Sir.

#16

Hi KarthikByggari Sir,

Any progress…?

#17

I will check now and let you know.

1 Like
#18

Hi KarthikByggari Sir,

Ok Sir.

#19

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
#20

Hi Deepak94 Sir,

I can’t get it out your reply.

#21

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