Excel Reporting

[MD2050]

Hello Everyone-

Is there a way i can report out hourly numbers for a day within a new excel workbook for ever day ? meaning for today's date i should get an excel workbook with 24 worksheets (at 11:59 pm) for each hour starting from midnight and then for tomorrow the workbook should start with tomorrow's hourly data after midnight. 

Thank you very much. 

[ivoller]

Can you post sample data?

[mborriero · Accepted solution]

Hi @MD2050,

Are you looking for something similar to the attachment?

[MD2050]

Hello @mborriero- 

Thank you very much for the code. I however don't see a Test.xlsx file output to my local machine, wasn't it suppose to do that ? please advise. 

Thank you.

[mborriero]

It will save a file with the name of the day.
You will need to save the file in one of your directory, then select a
valid path on your laptop (instead of the path of the test file).
The file will be saved in the same directory of your workflow.

[MD2050]

Thank you @mborriero- 

I changed the path in the Output tool however I didn't changed the file path under the Formula tool which was the reason the program was dumping the test.xlsx file under the Downloads folder instead of the required folder. 

Yes, this is exactly what i was looking for .

Thank you very much for helping.