Connect HomeMarketplaceComponentsNovigo Solutions - Enhanced Read Range

Novigo Solutions - Enhanced Read Range

Snippet

Snippet

Updated: October 21st, 2020

Published: March 11th, 2020

Downloads: 23

Industry: Utilities

Language compatibility: Visual Basic

Community Support

Novigo Solutions - Enhanced Read Range

Snippet

Summary: 

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

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

Details

Benefits

Excel file with duplicate column names can be read and modified to columns with unique names provided by the user.
Can be used as a normal Read Range as well.

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

Resources

- User_Guide.pdf

Licensing

By clicking download you agree to the following license.