Connect HomeMarketplaceComponentsNovigo Solutions - Convert CSV in Xlsx or Xls

Novigo Solutions - Convert CSV in Xlsx or Xls

Snippet

Snippet

Updated: October 20th, 2020

Published: May 19th, 2020

Downloads: 50

Industry: Utilities

Language compatibility: Visual Basic

Community Support

Novigo Solutions - Convert CSV in Xlsx or Xls

Snippet

Summary: 

This Snippet is used to convert CSV files into Xlsx or Xls

This Snippet requires the following six arguments:

Input Arguments:

1. in_FolderPath (String): The Folder Path which contains the CSV files that need to be converted. Optional.
2. in_CsvFilePaths (String []): This Input argument can be used when the CSV files that need to be converted are in different locations. The Array of file paths can be provided. If the in_FolderPath argument is provided then this argument is ignored. Optional.
3. in_SheetName (String): The sheet name that needs to be provided for the converted output xlsx or xls file. Optional.
4. in_DeleteCsv (Boolean): This argument specifies if the original CSV files need to be deleted or not. Optional.
5. in_Extension (String): This argument specifies the file format needed. It can either be xlsx or xls. Required.
6. in_OutputFolderPath (String): This argument specifies the folder path where the Converted Output xlsx or xls files needs to be created. Required.

Note:
The in_Extension argument should be either xls or xlsx. If other extensions are provided, then the output file might be Invalid.

Details

Benefits

Used to convert CSV files into Xlsx or Xls. 
Conversion of files to xlsx or xls enables more functionalities for the file such as adding more sheets.
Conversion of files to xlsx or xls also enables to add formulas.

Compatibility

Compatible with all Studio versions starting with 2018.4.1

Dependencies

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

Resources

- User_Guide.pdf

Licensing

By clicking download you agree to the following license.