While writing text file in CSV some column getting blank

Help Studio
1

Hi all,m converting xlsx to CSV .
My flow is
Excelscrope app
Read range: dtconcert
Assign
Datalist: (from d in dtconcert .asenumerable let s= string .join( “,”,d.itemarray)select s).tolist
Assign
Strcsv:string.join(environment.newline,datalist)
Wrtite text file
In text strcsv and filename
So in my xlsx I have , in H column so while converting , is gone and it gives to empty spaces and then next record .et is d issue pls suggest

IMG20220810160253
IMG202208101602531920×1440 330 KB

IMG20220810160236
IMG202208101602364624×3468 2.2 MB

2

Your approach is incorrect.

Read Range to get the data into a datatable, then Write CSV to create the CSV text file.

3

Hello @sayali_rokade ,

If your objective is just to write to CSV from Excel then you can perform the following :

  1. Use Read Range to read the Data & Store in a Data Table Variable
  2. Use Write CSV , Pass the DataTable & Delimeter, file path, you will have the data in CSV format.

Regards,
Rohith

4

Hello @sayali_rokade - Hope the attached workflow would helps you!!

Example.zip (9.7 KB)