Getting Null Values In Excel

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi,

While i was reading and writing data to different excel… I was getting the data with some null values(ex ,)

How I can remove…? I have deleted and created new excel as well

I have attached the snapshot below for reference.

Thanks,
Rishi

[Anil_G (Anil Gorthi)]

@Putta_Sri_Sai_Rishik_Chow

After reading the data you can use a filter on any of the columns where you would definitely have data and use IsEmpty filter in filter datatable activity

Cheers