This video explains the method to copy selective columns from one sheet and paste into another workbook/sheet.
Method Used:
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 .
Sudheer is an industry acknowledged expert in the technologies like UiPath, C#, VBScript, VBA, VB.Net, MVC, ASP.NET, SQL Server and Web Tools like HTML, JavaScript, JQuery, Angular JS, Sudheer is vastly experienced in team management, mentoring teams, and directing all stages of software development.
