How to make it dynamic for excel reports

Help Activities
, ,
1

hi everyone,
I need help. I want to make a daily report for a vehicle rental place where every day there will be the amount of income and the number of vehicles rented on the report. (1st photo of sample report , 2nd photo of incoming data every day & 3rd photo of the UiPath activity that I have made)

1
1655×560 12.7 KB

2
2301×524 6.11 KB

3
3323×503 19 KB

I’m having trouble when I want to make it dynamic to generate the report every day on the same sheet. What activities should I use so that formulas in excel can run dynamically every day? I really need your help. Thank you all

2

I’d start as followed:

  • Read Range Input Excel Sheet
  • Filter DataTable for todays date (just use “now.toString”)
  • Count Type Motorbike rent and Car rent

Now to write the data back, should the whole report or just a daily report be generated?

3

halo @iamNairda ,

thank you for replying. still not like what I mean sir. maybe there’s another way to automatically write to the side (next day)? Thank You

4

anyone can help me? I really need your input ideas. thank you :pray:

5

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