.XLS TO .CSV With intermediate data table

Help
, ,
1

Hi
I am reading a data from XLS deleting a column in excel by using “remove data column” and then converting the excel in to .CSV by using “write csv” activity.
While converting “#NA” from excel sheet is converted as -2146826246

2

Hello!

Have you tried to loop through the xls file and remove all the #NA before converting it? Maybe if you replace all #NA with blanks or with another value it will work.

Regards,

3

@Lucas.Pimentab Thank you I will try it.

4

Hi tried the above but the problem is I have more that 700 XLS and #NA might appear in different rows and columns.
Can some one help me with it.