Fetching data from excel

Hi
I have attached a excel file kindly have a look and solve my issue.
we have two rows URL and Marks.
Ui path will fetch URL from excel and hit
for each url coresponding marks are entered.
marks must be splitted by “,”

suggest the methods to be followed.
Any methods to know the row number and column numbr of a particular data.

1 Like

Buddy kindly attach the excel @KarthikBallary

student.xlsx (8.2 KB)

Buddy @KarthikBallary
here is your xaml
its resolved
splitcell.zip (8.5 KB)

Kindly try this and let know buddy
Cheers @KarthikBallary

Hey Thanks for giving time.But My issue is not about spliting
I will send you html file you will get to know
Html.zip (847 Bytes)

buddy may i know what was issue with this @KarthikBallary
do you want to enter to these html pages
Cheers @KarthikBallary

yes. first row url must enter first row marks
second row rul must enter second marks

1 Like

Fine here you go buddy @KarthikBallary
splitcell.zip (19.2 KB)

kindly try this and let know buddy
Cheers

1 Like

My isssue is
all the marks column data are entered to first url, second url etc
My requirement:
first row url coresponding row containing corespnding marks must be entered

1 Like

check the last one with attachment buddy that would work
is that …
cheers @KarthikBallary

Thank you will check and let u know

1 Like

did that work buddy @KarthikBallary

i am create student mark sheet in uipath
Column(A).subject 1 Column(B) subject 2 and Column (C) total mark will be not adding in (c) column.

HELP ME      (Adding to descending order not adding ascending order)

https://drive.google.com/file/d/1_wqcmaR0lB9ilULQayiKbGN7tNYUCd4c/view?usp=sharing
me excel file

Very sorry for the late reply.
Its working fine, Thank you so much

1 Like

Fantastic buddy @KarthikBallary
Cheers

Buddy remove the extension and add it again buddy @KarthikBallary

I have tried all
reintsall studio
reinstall extension
enabling developer mode

this could help you buddy @KarthikBallary

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.