| Info |
|---|
This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial. |
| CSV2XLSX |
|---|---|
Co-Authors: Irene Cho / Jerry Chae
Description This plugin simply converts a CSV file to Excel (.xlsx) file. It is only one-way conversion. |
Required Input
- One CSV file
Optional Input
- Output folder/file name --- if you leave this unchecked, output file will be created in the same folder as the source CSV file with the same name except for the extension.
- Cell/Range --- this option can be checked if you wish to convert numeric value of the CSV data into some specific format after conversion to an Excel file.
- Format --- this option used together with the Cell/Range option. You can choose the format from the pull-down menu. Please make sure the source CSV data is a string of 0 to 9.
- More explanations at this link. https://exceljet.net/custom-number-formats - Encoding option – select encoding format if different from UTF-8
- List format --- when this option is checked the Return Value will contain the list of Format from the pull-down menu above.
Output/Return Value
- A full file path of the output Excel (.xlsx) file
How to set parameters
Return Code
Code | Meaning |
|---|---|
| 0 | Execution successful |
| 1 | Execution failed |