Create your first automation in just a few minutes.Try Studio Web →
by Novigo Solutions
5
Snippet
220
Summary
Summary
This workflow detects the duplicate column names and renames it by adding the number of occurrences as suffix.
Overview
Overview
This Snippet requires three arguments:
Input Arguments:
1. in_FilePath (String): Path of the Excel file for reading and renaming the duplicate column names. Required.
2. in_SheetName (String): Name of the sheet in Excel file for reading and renaming the duplicate column names. Required.
Output Arguments:
1. out_DataTable (DataTable): This is the output argument which returns a DataTable after renaming the duplicate column names. Required.
Features
Features
This workflow renames all repeated column names and also makes sure that the renamed column names are not repeated.
Additional Information
Additional Information
Dependencies
UiPath.Excel.Activities UiPath.System.Activities
Code Language
Visual Basic
Technical
Version
1.0.0Updated
July 16, 2020Works with
Studio: 18.4.1 - 22.10
Certification
Gold Certified
Support
Email: Harshith.Adyanthaya@novigosolutions.com
Business Hours: Mon-Fri 9 AM to 6 PM IST; Response time: 1 business day (24 hours); Resolution time: 15 days.
Resources