I want to create excel sheet on monthly basis

Help Activities
1

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.

2

Hi

you can use INSERT SHEET activity where in the sheetname mention like this
Datetime.Now.ToString(“MM”)

Cheers @Bhushan_Nagaonkar

1 Like
3

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

4

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

https://docs.uipath.com/activities/other/latest/productivity/append-range

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

hope this helps
@Bhushan_Nagaonkar

5

So sr. No so will it append?

6

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
@Bhushan_Nagaonkar

7

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

8

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

9

Screenshot_20230905_172830_Sheets
Screenshot_20230905_172830_Sheets697Ă—1291 76.3 KB

Hope it helps

10

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

11

So in sr. No tab even if we re run the script it should increase only from the previous row no.
1
2
3
4
5
6

12

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()
regards,

13

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

14

hi @Bhushan_Nagaonkar
Is output correct?

15

I have to try.

I will let you know.

16

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