.XLS TO .CSV With intermediate data table

excel
csv
activities

#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.