How to convert CSV to Excel

[pravin_bindage]

I tried read csv & write rang but its not working,Same csv writing in excel

[pravin_bindage]

@Yoichi its not working

[Anil_G (Anil Gorthi)]

@pravin_bindage

Is the column separation comma?

or is it different?

If different then use read text and generate datatable and then write range

cheers

[pravin_bindage]

What should i do in this type scenario where csv contain multiple column it results like this
→ Column G
@Anil_G

[Anil_G (Anil Gorthi)]

@pravin_bindage

In generate datatable use ; as the column separator

cheers

[pravin_bindage]

yes i’m already using that still results this

[Anil_G (Anil Gorthi)]

@pravin_bindage

After generate datatble activity is the datatable not separated into columns?

Can you show your flow please

cheers

[pravin_bindage]

[Anil_G (Anil Gorthi)]

@pravin_bindage

Please change format to custom

cheers

[pravin_bindage]

Not working still

[Anil_G (Anil Gorthi)]

@pravin_bindage

So you have comma and semi colon as separators?

can you please share a sample file here

cheers

[pravin_bindage]

access-code-password-recovery-code1.zip (429 Bytes)

[pravin_bindage]

can we use multiple column separator in generate data table activity ?

[Anil_G (Anil Gorthi)]

@pravin_bindage

After reading the data, say the data is read into variable str

then use assign with str = str.Replace(“,”,“;”)

then

We can replace the remaining separators to the required and the generate

cheers