Copy Excel Sheet in UiPath|Excel Automation|UiPath RPA Tutorial

[@UiPathRPA]

Let's learn - How to copy a sheet with format and paste to another sheet with existing data.

[@poonamshinde3928]

Hi I have one error in copy sheet activity

[@UiPathRPA]

What is that error?

[@poonamshinde3928]

@@UiPathRPA unable to cast com object of type system com object to interface type Microsoft office introp Excel workbook

[@UiPathRPA]

Can you please share workflow via mail?.. [e-mail]

[@poonamshinde3928]

@@UiPathRPA yes

[@arijitr298]

Really helpful. Well explained.

[@UiPathRPA]

Thank you Arijit!

[@harikamaddineni9663]

How to copy date format

[@ramn784]

iam getting error has:Job Stopped with unexpected exit code:0xc0000005 Can u help me

[@aprendiendorpauipath2759]

Hi, I wanted to congratulate you and thank you for your videos, do you have a video where you work in Excel and start looking for a value (ex: C) from a cell that can be A8 but we don't know where the search will end one day it can be A19 another day A43 another day A44 and so on.

[@ashishyadav-vi3uq]

How to copy a sheet from one excel to another excel file which has a password?

[@UiPathRPA]

Hi Ashish, currently there is no option for this. You can try if it works otherwise you have to use the excel without password protected.

[@ashishyadav-vi3uq]

@@UiPathRPA thanks for your prompt response. I came accross a custom activity called 'copy to file' using which we can do this. Thanks once again for your awesome videos 😊