Connect HomeMarketplaceComponentsNovigo Solutions - Excel Template Creation

Novigo Solutions - Excel Template Creation

Snippet

Snippet

Updated: September 4th, 2020

Published: March 24th, 2020

Downloads: 12

Industry: Utilities

Language compatibility: Visual Basic

Community Support

Novigo Solutions - Excel Template Creation

Snippet

Summary: 

This Snippet is used to create an output Excel template which consists of only the headers of the input Excel file

This Snippet requires the following six arguments:

Input Arguments:
1. in_InputFilePath (String): The input Excel file path. Required.
2. in_OutputFolderPath (String): The folder path where the output Excel template needs to be created. Required.
3. in_OutputFileName (String): The name of the output file that needs to be assigned (without extension). If not provided then the input file name is the default value. Optional.
4. in_SheetsDictionary (Dictionary(Of String, Integer)): The dictionary mapping of the sheet names and its corresponding start row number in Excel sheet. Required.

Output Arguments:
1. out_TemplateCreated (Boolean): Indicates whether the template creation is Successful or not. Required.
2. out_OutputFilePath (String): The output file path of the template created. Required.

Details

Benefits

Useful when the format of the headers in the input Excel file are needed to be the same in the output Excel file.

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.