Copy values from excel to CSV issue

[oshan (Oviya S)]

Hi friends,

I am reading an excel that has date on AI column.

I use read range and filter option, and then i will write the output into CSV file.

Output comes in the below format. its copying the blank data as 0 and date format is changed

I gave preserve format in read range workbook , still its coming as above, any solution for this

[vamsiyeluri]

@oshan use format activity, go through attachment you will find the solution for your problem.1.xlsx (9.0 KB) Example.xaml (9.9 KB) Test-1.zip (164.0 KB)