Create a excel with header every first day of the month

Help Studio
1

Hi i like to create a excel with a header every month of the first day how can i do it!

2

Hi,

Hope the following helps you.

img20210416-2
img20210416-21175×790 43.4 KB

Regards,

1 Like
3

Hi @CoolRobot

Could you please let us know how many headers you need in excel and how it should be.

Thanks

4

14 headers

image
image935×33 2.42 KB

thanks

5

Hi again @CoolRobot

Please find the below screen shots for your reference. Try and let me know whether it meet’s your expectation.

Total workflow:
image

Assign Values:
image

Generate DataTale property panel:

image
image255×592 11.5 KB

You have to publish this package to orchestrator and trigger this package on first date of
every month.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

6

hey thanks but what about say Month and week that a formula for it
Month = text(C,“MMM”) C mean this column downward C1,c2c3 etc
Week = =WEEKNUM(C,2) C mean this column downward

7

I am not cleared on the above one @CoolRobot

Inside the Month and Week column, you need month name and week number by validating column ‘Date’.

For Example: if date is 16/04/2021, then the Month should be April and week should be 3.

Correct me if I am wrong.

Thanks

8

yes correct

9

Okay @CoolRobot

How you will get the date values. So that we can design the flow. Thanks.