How to create new excel file in specific location?

Help Something Else
1

Hi There,

I want to create new excel file in specific give location.

Example : "Excel Name_08/02/2023 18:55.xlsx

How to achieve this ?

2

Hi @Muralikrishna_Surve ,

Try using Write Range Workbook Activity by specifying the location of the file and also the Sheet name of your choice with the value as new Datatable().

Let us know if it does not work.

2 Likes
3

Another Method @Muralikrishna_Surve is same as @supermanPunch suggested but with excel activities

image
image1251×442 35.2 KB

1 Like
4

And for the file name you can use this expression @Muralikrishna_Surve

"ExcelName_"+Now.ToString("dd-MM-yyyy")+".xlsx"

You cant create a file name with the / in it so use - or _ in Filename

Regards
Sudharsan

5

@Muralikrishna_Surve

Use write range activity & under file details use this
Excel Name _dd/MM/yyyy hh:mm.xlsx

You will achieve your requirement

Thanks
Varun

1 Like
6

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