Update status row wise in excel


#1

Hi Guys!

I am new to UIpath.

I have a scenario here,

Steps,

1.Open google browser and search for different books (Which is in excel)
2.Verify the book obtained in the first search list is same as the one in the excel row.
3.Write the searched book row in results excel row by row after a particular row from data excel is entered in the application and also update the status as pass or fail(if the compare result between google search and data excel matches) in the results excel.

Can someone help me out with a sample XAML.

Thanks


#2

Hey there,

Welcome to UiPath community forum.

Please refer below example which is available in UiPath knowledge base.

I encourage you to take up UiPath academy training to kick star RPA .(It’s free though :slight_smile: )

Happy Automation,
Cheers :+1:


#3

Thanks for the reply,

I have completed my foundation training.

I tried using right range - but the entire range goes into the results excel.

I want to write the row that got executed to excel and and update pass or fail next to it.


#4

{

  • Excel application scope(for your excel file)
    - take “for each row”
    +take a variable for ur book name using assign
    assign
    to(bookvariable)=(row(bookname).tostring)
    + Open Google browser
    +typeinto activity with bookvariable
    +do data scrapping now and attain first book name bookweb variable
    +If (bookvariable=bookweb)
    if yes
    (write cell (row(status).tostring=YES))
    if no
    (write cell(row(status).tostring=NO))
    +close application for web
    }

#5

Thanks for the suggestion Sravya. I will try this out and update you.

Is there any sample XAML for fetching data from excel and updating the status?


#6

Thanks for your suggestion.Its working cool now.

I have one small problem,When I write the status to my excel.

It always prints the values from line 10.

Kindly advice


#7

@karthyk, Confirm your counter variable declaration once.

Regards,
Dominic :slight_smile:


#8

counter=0


#9

Hello @karthyk

it is clearly visible in image you are already using cell argument as like “A1”+counter.tostring so even if your count will be 0 then it will become A10.

so replace “A1”.counter.tostring to “A”+counter.tostring.

Regards…!!
Aksh


#10

Hi Aksh,

Thanks for your suggestion,

but when i use “A”+counter.tostring, range not found error is displayed.

Regards
Karthick


#11

Yes initialize your counter with 1 not with 0 :slight_smile:


#12

Thanks bro. Working cool now :slight_smile: