How To Insert Generated Data, Based on Some Condition into an Existing Excel DataBase

Help
1

Dears,

I was able to calculate the Time Difference Between a Given Date/Time and Actual Date/Time in Seconds, but I was not able to Insert the Generated Data Based on some condition, into Existing Excel Data Base.
Please find the following Snapshot for more clarification :

image
image1168×355 138 KB

2

@hsendel
Once you have the value you can use write cell activity within a if condition and can validate the value with the condition you have buddy

Cheers

3

Thanks for prompt Feedback Palaniyappan:grinning:
Do I need to write cell at the end of each output ( B,C,D, and D) or a Common one?
Also , What should be the Syntax of Cell Range Supposing Result Column is in Column “C”?

4

Yes buddy @hsendel
the range format would say for example if you want to write 20 row in C column mention like this
“C20”

Kindly let know whether that works or not buddy
Cheers @hsendel

5

It is inserting all values in same cell. By the way how to write range for “write cell” activity, so that it will insert only the related value from A,B Columns?

6

Use a counter of default value 20 say for (row 20) and increment them to enter into cells one by one below. Use this increment within a loop buddy that would work @hsendel

8

Could Humanizer get this job done in a best way? (managed from Robot Side, only Write Results to Excel and avoid Tedious Formulas) http://humanizr.net/

9

Thanks Palaniyappan.
Worked after Using Counter and Write cell Activity for Each Output.

1 Like
10

Thats fantastic buddy
Cheers @hsendel
Keep going …

11

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