This video explains the method to copy selective columns from one sheet and paste into another workbook/sheet.
1- Read entire excel sheet into a datatable
2- Create a View with only selective columns.
3- Convert the view to datatable
4- Write the new datatable to an excel sheet/file.
Watch the video for detailed explanation.
Sudheer Nimmagadda is a Automation Developer based out of Bangalore, India. He has over 8 years of software industry experience in various roles including Software Module Lead, SSIS Developer, Dot Net Programmer, and Automation Lead. Sudheer was completed certifications like UiPath Foundational , Orchistrator, SAP Automation and he participated in UiPath Power Up Automation Program in UiPath Headquarters Banglore , India .