Novigo Solutions - Convert CSV in Xlsx or Xls

Bronze Certified

Snippet

3 reviews

Version:1.0.0

Overview

Reviews Questions

Versions

Summary

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

Overview

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.

Benefits

Published: 22 May 2020 | Updated: 30 Oct 2020

Novigo Solutions

Trusted Source

License

3-Clause BSD

Code Language

Visual Basic

Runtime

.NET Framework

Novigo Solutions - Files Segregator…

Snippet

This Snippet is used to divide/segregate different types of files of present in a folder into separate folders based on their type…

1 reviews

Bronze Certified

Supported by Publisher

Novigo Solutions - Dictionary To HTML Form…

Snippet

This Snippet converts a Dictionary Key Value Data into a HTML Form in a String Format…

1 reviews

Bronze Certified

Supported by Publisher

Novigo Solutions - Regex Replace…

Snippet

This Snippet helps to replace a pattern in a string for a required number of times, or only the first occurrence or the last occurrence or all the occurrences needed…