What error you are getting?
And also give more details how you are entering excel data into website!!!
Regards,
Karthik Byggari
What error you are getting?
And also give more details how you are entering excel data into website!!!
Regards,
Karthik Byggari
Can you please elaborate your process. What you are trying to do?
Check your inbox.
Hi Sir,
I have sent you a mail Sir.
I will check. I got busy with other important work. I will let you know soon.
I will check now and let you know.
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!
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!
Hi Deepak94 Sir,
The above changes is getting error Sir where it’s getting double time of case type and case no.
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