Creation of dynamic excel file

Hey,
I want create one excel file and file name is summary report1 with today’s date & time and for this I am using excel application scope inside that I am using this code-“C:\Users\Administrator\TruBot\POUpdateToSAP_Automation\Operational\Output\Summary Report1 as on “+now.AddDays(1).ToString(“dd”)+” “+now.ToString(“MMM”)+”’”+now.ToString(“yy”)+"-CC"+".xlsx"
And it showing me that now is not declare
Could you please help me for this

Hi @kailas_jadhav

Try this expression
“C:\Users\Administrator\TruBot\POUpdateToSAP_Automation\Operational\Output\Summary Report1 as on"+Datetime.Now.Tostring(“dd MMM yy”)+"-CC.xlsx"

Regards
Gokul

1 Like

@kailas_jadhav

Check as below

It’s working, so can you recheck it again and where you are declaring this value?

Thanks

no it’s not working it showing me now is not declare

@kailas_jadhav

Can you share the screenshot of workflow and the error

Thanks

This expression is worked for you. If not let me know.

or else
Close this topic @kailas_jadhav
Happy automation

Regards
Gokul

Sorry for inconvenient
but its not working

Can you share the screenshot for the workflow @kailas_jadhav

yes.