Error while retrieving data from Excel

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

Hi KarthikByggari Sir,

Any progress Sir…?

Hi Deepak94 Sir,

The above changes is getting error Sir where it’s getting double time of case type and case no.

Hi KarthikByggari Sir,

Any progress for my related query Sir.

Use the following activities -

**Excel Application Scope**
  --**Read Range Activity** to read the data from the Excel and saved to DataTable say DT
End of **Excel Application Scope**

Use For Each Activity to read one row at a time.
Create the following variables in Variables Panel
strCaseType, Data type : String
strCaseNo, Data type : String
strYear, Data type : String

For Each row in DT
    Assign Activity, strCaseType = row(0).ToString
    Assign Activity, strCaseNo = row(1).ToString
    Assign Activity, strYear = row(2).ToString

    //Add a sequence to enter these values into a website
     Use Type Into activities

Regards,
Karthik Byggari

1 Like

Hi KarthikByggari Sir,

Can you share me the workflow through mail…Sir.