Creation of dynamic excel file

Help Studio
, ,
1

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

2

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
3

@kailas_jadhav

Check as below

image
image1177×314 17.6 KB

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

Thanks

4

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

5

@kailas_jadhav

Can you share the screenshot of workflow and the error

Thanks

6

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

or else
Close this topic @kailas_jadhav
Happy automation

Regards
Gokul

7

Sorry for inconvenient
but its not working

8

Can you share the screenshot for the workflow @kailas_jadhav

9

yes.