UiPath- Convert the column of numeric (decimal) value which has “.” into “,” of a csv or excel file.
INPUT
Input: An excel file
Name: input.xlsx
Adding a screenshot of the excel file.
OUTPUT
Output: An excel file
Name: input.xlsx
Adding a screenshot of the excel file.
FLOW
To achieve the desired output, please follow the below steps:
1. Open UiPath Studio. Select “Process.”
2. Create a new process by entering a valid name and change the description to something meaningful. Location must be the path where you want to save the process.
3. From the activities panel, select a sequence or a flowchart. I’m starting with a sequence. Rename the sequence to something meaning. Add annotations.
4. Select the Excel Application scope from the activities panel in the sequence. Give the path to the Excel file.
5. In the Excel Application scope, use a Read range activity. Be careful here, there are two Read range activities, One for Excel and the other for workbook. If you use the Workbook’s Read Range, then do not use the excel application scope. Since we are using Excel Application Scope, use Read Range for Excel.
Path must be given in between “ ”.
6. The properties of Read Range are shown below. Output of Read Range must be of type Data Table. Create a new variable from the Variable panel or use ctrl+K to create a variable.
input_Datatable is the variable I’ve used in the Output tab. It holds all the contents of excel.
Datatable: input_Datatable
AddHeaders: True
7. In the variable panel, extend the scope of the data table to the entire sequence.
8. Use a “for each row” activity. The contents of this activity are:
Datatable: input_Datatable
9. In the body of “for each row” use an assign activity.
10. The contents of Assign activity are:
To: row(“Numeric Value”)
Value: row(“Numeric Value”).ToString.replace(“.”,“,”)
Where “Numeric Value” is the column name
11. After this use an “Excel application scope” with a write range (for Excel) activity.
The path must be the same as in the read range. The contents of write range are
Sheet Name: Sheet1
Starting Cell: “A1”
Datatable: input_Datatable
Add headers: True
12. The whole flow is shown below:
I really hope this solves your doubt. Feel free to reach out to me for any further queries.
To view some more UiPath related contents, please follow the below link:
Or visit my page
To view my other work, please visit the below links:
Always remember to be kind.
All the best and Happy learning!
