Rewrite certain values in existing excel

Help
1

Greetings of the day…

Capture5
Capture5953×270 7.16 KB

I had given a task where is scrap the rating from email and update in the above excel. I should also change the status as “assessment Completed” with time stamp only when the rating is available and written in excel. how to overwrite this .

2

@soumi_soumiya

1, Read the Excel and convert to Datatable using For Each Row
2, Inside the body
3, Assign the value to row(“Rating”).tostring
4, then using IF condition based on the rating updated the status column (row(“Status”).tostring)

Hope this will help you
Thanks,
Suresh J

1 Like
3

Input :
image

OutPut:
image

Code:

image
image485×691 17.8 KB

Variable Pane:

image
image1108×136 8.7 KB

Same Way In the If condition - You can specify Your own condition and update Date as well.

–
Mukesh

2 Likes
4

Good afternoon Soumi,

You could also read the range from Excel, update the values in a for each loop, and then just write the entire range back to Excel at once.

2 Likes
5

pic I am facing this error.

6

I would like tell you the full steps in detail
But may I know what we’re going to scrape based on which we are going to update
Kindly elaborate this pls

And the reason for the above error is if condition can take only BOOLEAN inputs
While row(“Status”).ToString is a string value
We can validate like
String.IsNullOrEmpty(row)”Statis”).ToString)

But that’s the reason why I m asking for that description in a elaborative way so that we can use a exact condition to be used here in if condition
Cheers @soumi_soumiya

1 Like
7

Thanks for your reply…
My task to select the key supplier from the given database and send them the risk assessment form.The key supplier id, Email, and status with timestamp I had updated in an excel as given below.

Capture5
Capture5953×270 7.16 KB

Then the supplier or the client fills up the form and sends me as given below.
1
This is the feedback form I what that I receive in the mail. I need to scrap the number and average performance. When the scraped number is matched with id mentioned in the excel the rating gets entered in the rating column. Now I need the change the status as risk assessment received and also the received time in the time stamp. I don’t know how to overwrite only for a particular value that has a rating.
I uploading my workflow too…
Flowchart.xaml (18.6 KB)

1 Like
8

Sorry for the delayed response
I saw your workflow and I was editing it
But sorry my lap got switched off
—no worries
I will tell you the steps to be followed
—along the sequence from select method in assign it was fine
—while remove all activity from that assign activity with select method
—hope these steps would help you resolve this
Use a for each row loop and pass the input as get_id -the datatable variable
—inside the loop use a if condition like this
row(0).Tostring.Equals(yourgettextoutputvariable.Tostring.Trim)
If this is true it will go to THEN apart where we can include assign activity like this
row(“Status”)=“Assessment completed”

—then after this for each row use a write range activity where pass this datatable as input and make sure that Add Headers property is enabled

Cheers @soumi_soumiya

2 Likes
9

Any other queries to be discussed buddy
Cheers @soumi_soumiya

10

Thanks for your reply…
I am trying with my flow it got merged so starting new flow. Once trying ur suggestions i will let you know buddy

1 Like
11

which one are you saying can be more clear please

12

hai Row(0) cant be quoted in my flow. this my full workflow hope so now it will be clen clear about my flow Main.xaml (40.4 KB)

1 Like
13

No worries
If possible can I have screenshot of the sequence as I don’t have the system with me
But I can tell the next steps with the screenshots
Cheers @soumi_soumiya

1 Like
14

Thanks for your reply…
I had got cleared with my sequence thanks for guidance

1 Like
15

Great
Cheers @soumi_soumiya