Get Todays Date and save the output excel file

Help
,
1

Hi I want to save the workbook in a separate file, its throwing on error and any one suggest how can i save the output file in excel application scope and that file name should be in YYYY-MM-DD_output.xlsx format

image

1 Like
2

Fine
let me tell you why it is throwing error
–the reason is the workbook is the output variable that gives us the workbook variable type as output from the excel application scope

so to save the excel with that timestamp we can include that in the excel application scope, while passing the file path as input mention like this
Now.ToString(“yyyy-MM-dd”)+“_”+“output.xlsx”

or once after writing all the data to the excel we can use MOVE FILE activity with source file path mentioned and destination file path as
Now.ToString(“yyyy-MM-dd”)+“_”+“output.xlsx”

either of this would work
hope this would help you
Cheers @Shriharsha_H_N

3

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