When I use csv to excel file converter in uipath, some value contain (,) within the CSV. such as
So the converted columns are in the wrong column due to (,) in the xlsx file.
This is my sample activity for that. Thanks.
Kindly suggest what can i do for that one. thanks
Thanks for your solution but this doesn’t meet my requirement. As CSV file already contain comman. Thanks.
@Htwe_Ko_Ko_Wynn Can you follow these Stpes and Check if it works?
- Use Read Range for the Excel file and get the Output Datatable.
- Use Write to CSV Activity and Supply the Output Datatable to it.
If this Doesn’t Work, we might need to Convert the Comma in your values to some other delimiter , and then Convert it back while retrieving.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.