Csv to excel comma contains columns error

Dear All,

When I use csv to excel file converter in uipath, some value contain (,) within the CSV. such as

image

So the converted columns are in the wrong column due to (,) in the xlsx file.
image

This is my sample activity for that. Thanks.


Kindly suggest what can i do for that one. thanks

This link may help you, @Htwe_Ko_Ko_Wynn
https://www.e-iceblue.com/Knowledgebase/Spire.XLS/Program-Guide/CSV-to-Excel-Convert-CSV-to-Excel-with-C-VB.NET.html

Hi Manish,

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?

  1. Use Read Range for the Excel file and get the Output Datatable.
  2. 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.