How not to read null value in excel while writing to excel or text file?

[Dorothy_lee]

Hello!

I’d like to make exception for Null value. For example, if excel row data is Null, I don’t want to write it to text file or excel file.
Based on current process, it’s getting Null Value as well…

text file /Print Result

Excel file

[prasath17 (Guru)]

@Dorothy_lee - I guess, this has been answered already … did you give it a try??

Can I send Outlook e-mail based on excel data condition?

@Dorothy_lee - you have to add another and condition on the dtfiletred itself to control the null datarows… update: DtFiltered = (From r In Dtout.AsEnumerable Where r("Feedback").toString.Contains("FALSE") and (not r("Feeback") is Nothing orelse Not String.IsNullOrEmpty(r("Feeback").ToString)) Select r).CopyToDataTable

[NIVED_NAMBIAR (NIVED N)]

Hi @Dorothy_lee

Is the null values rows are between the datatable row values?

May I know about that

Regards

Nived N

Happy Automation

[Dorothy_lee]

@NIVED_NAMBIAR Hello, Thank you for your reply !
It’s resolved through below inquiry!

Can I send Outlook e-mail based on excel data condition?

@prasath17 Thank you so much! It’s perfectly working now… !