BalaReva Easy Excel Activities

Hi Bala, it would be really helpful if you could please help me with building a robot that has the below mentioned objectives.

When provided with an excel sheet with 8 columns of which one is 'date' ,(1) the bot filters all the records in the excel on the basis of date and deletes all the records with previous month, (2) marks all the records with a date prior to today's date in orange color fill, (3) marks all the records with current date in red fill, (4) copies all the cells from excel pastes in outlook and sends it across to a specific mail ID.

I am new to the technology , I've done basic udemy courses, but this seems to be a challenge .

Regards,

Raj Kale

Hi Balamurugan, I recently developed two activities for Excel that I want to share with you. I know you have done a lot of good work in UiPath, helping others in the community and contributing to the Resusable components.

I needed two activities, one to split an existing Excel file into multiple files and another to merge them back. Instead of creating yet another Custom Activity, I want you to add these two activities within your library, if that helps. Let me know, and I will be happy to share the files with you.

Hello, I am not sure if you will check this. Thank you for writing this activity. But I am having a problem just running a simple get LastRow. The error is "Find LastRow: Object reference not set to an instance of an object.". I have set Sheet Name = "Apr 2020", Delay  = 1 and Row Index = lastRowIndex (variable). Is there anything I am doing wrongly?

Thank you!