MarketplaceListingsSnippetNovigo Solutions - Enhanced Read Range

Novigo Solutions - Enhanced Read Range

Supported by Publisher

Silver Certified

Snippet

3 reviews

54

Novigo Solutions - Enhanced Read Range

Supported by Publisher

Silver Certified

Snippet

3 reviews

54


Summary

This Snippet provides the feature of reading an Excel file with duplicate headers and renaming it with user specified header names

carouselImage0

Overview

This Snippet requires the following five arguments:

1. in_FilePath (String): The Input Excel File Path. Required
2. in_SheetName (String): The Sheet Name that needs to be read. Required
3. in_NewColumnNames (String[]): The New Column Names that need to be replaced with the Old Column Names or Duplicate Names. Optional
4. out_OutputDatatable (Datatable): The Output Datatable after performing the operation. Required
5. out_DuplicateColumns (Dictionary(Of String,Int)): The Duplicate Column Name as the Key, the number of Dplicates as the Value. Optional

Benefits


Published: 17 Mar 2020 | Updated: 14 Dec 2020

Trusted Source


License

3-Clause BSD


Code Language

Visual Basic


Runtime

.NET Framework


Tags

Duplicate Columns
Enhanced
Duplicate Column Names
Read Range
Rename Columns

Compatibility

Compatible with all Studio versions starting with 2018.4.1


Dependencies

1. UiPath.Excel.Activities >= 2.4.6884.25683 2. UiPath.System.Activities >= 18.4.1


Documentation


Support

Email: arpan.bangera@ext.novigosolutions.com

Business Hours: Mon-Fri 9 AM to 6 PM IST; Response time: 1 business day (24 hours); Resolution time: 15 days.

Similar Listings