How to create a separate excel file for every month

[ushu (Usha kiranmai)]

Hello folks,

My requirement is to create a separate excel file for every month. Could anyone suggest how can do that

[cmrobertson (Corinna M Robertson)]

could you be a little more specific, do you want to create an empty file with a specific name for each month right now or do you want to create a monthly file?

[balupad14 (Balamurugan)]

Hello @ushu,

Here is the activity is called Create workbook(That is to create a new excel file.) with example file.

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Regards
Balamurugan.S

[ermanoj3101 (MANOJ)]

Hi Ushu,

Use Excel Application scope and give the path of file with current month and year.
ex- C:\Users\Desktop\xyz\FileName_“+Now.Month.ToString+”_“+Now.Year.ToString+”.xlsx".
If file with same month exist this will not create new file but if it’s not present then this will auto create file

[ushu (Usha kiranmai)]

Thanks everyone. Hope it works ermanoj. But, everyday it has to append the data in the next cell. How do we increment the counter. If we increment the counter once the process is finished for today it will back to its default value. How it knows it has to insert the data in ex A5 or A6. Please suggest on the same