Novigo Solutions is an end-to-end IT Solutions provider, specialized in full cycle IT Services and platform solutions

e6653b86-6191-494c-b705-57f8d49ea57c.png

1951c341-e12e-4bc9-a5fc-0f47d79273de.JPG

SOFTWARE ENGINEER

Very useful for Converting a CSV to Xls or Xlsx format, time saver.
Thank you for this useful snippet.

8c509776-82ba-4044-b8d7-bf1fca477ab5.zip

This Snippet requires the following six 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.

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

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

e7e4978b-7907-40ed-b772-26018c4fe56f.PNG

5371899b-1a2e-4b78-9894-0bdad0a0efa8.PNG

Copyright (c). All rights reserved.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

3. Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 'AS IS' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 

Novigo Solutions - Convert CSV in Xlsx or Xls

Novigo Solutions - Convert CSV in Xlsx or Xls