I want to create excel sheet on monthly basis

I want to create an excel sheet every start of the month and the process should automatically writ in that month.

I want sr. No also from 1, 2, 3, 4, 5 and so on in a single sheet even it is run multiple times.


you can use INSERT SHEET activity where in the sheetname mention like this

Cheers @Bhushan_Nagaonkar

1 Like

Thanks, how about sr. No is there any way and will it write data in the same sheet for whole month, without removing previos data

if sheet is there or not, activity will automatically create it,

if its there then it will use that
if not it will create one

so directly use APPEND RANGE workbook Activity so that it wont overwrite on the existing data…if you want to overwrite you can WRITE RANGE


in sheetname mention the above expression i shared to create sheet name on monthly basis

hope this helps

So sr. No so will it append?

sr. No is your Month number isnt it like 01, 02, 03, 04, …
so it will be able to create if not there or use the existing one

No…sorry for not explaining actually there are 5 columns and one of those column is Sr. No

can u share an image of the outcome you are looking for @Bhushan_Nagaonkar

Hope it helps

It is not clear, can you share image about expect output?

So in sr. No tab even if we re run the script it should increase only from the previous row no.

Hi @Bhushan_Nagaonkar ,
have you try For loop
each loop index = index + 1, value = value+1
write cell with A+index.toString()
with value.toString()

Im using while loop since I need the loop the process using counter for a particular activity

hi @Bhushan_Nagaonkar
Is output correct?

I have to try.

I will let you know.

Wont the index change for every run?
It wont be A always