Replace the months

[UJJVAL_BHAGAT]

I want all the data in this excel file to be same, I just need to change the months, which means in whichever month the bot runs then the month in the excel file should be replaced with the next 12 months
Please help me

Thank you

[lrtetala (Lakshman Reddy)]

Hi @UJJVAL_BHAGAT

Can you please show the expected output

Regards,

[UJJVAL_BHAGAT]

change only month and year depends what is the month and months should be the next 12 months

[adiijaiin (Aditya Jain)]

Hi @UJJVAL_BHAGAT

Here’s the logic, assuming that you get the dataTable from an Excel and is read into DummyDT.

You can follow the Logic in XAML File:
MOnthReplacer.xaml (13.4 KB)

Hope this helps!
Happy Automation!

[UJJVAL_BHAGAT]

when i runn the bot ,Then my data of 12 Current Month and Year is not coming , Yes the column names are coming .

i also want same data and only change column name.

[adiijaiin (Aditya Jain)]

Can you just share a dummy excel file with input and expected output?

If you don’t want to delete the data and just want to change the column names of your monthly columns.

[adiijaiin (Aditya Jain)]

hi @UJJVAL_BHAGAT

There you go.

MOnthReplacer.xaml (18.1 KB)

This one will retain your data and just would Rename the column as expected.

Thanks
Happy Automation!