Hi Team,
I am creating one dt with column “Comments”
at start I have to check if that column contains something or not … if yes then proceed if not skip it.
thanks,
Hi Team,
I am creating one dt with column “Comments”
at start I have to check if that column contains something or not … if yes then proceed if not skip it.
thanks,
Use If activity
Currentrow("Comments").Tostring.Trim.Contains("Something")
In then → You can skip he iteration
Regards
Gokul
Use another if activity - It will check the row count in the DataTable
Dt.Rows.Count>=1
Regards
Gokul
If there are 0 rows then how could the column have a value?
it doesn’t… that is why wanted to skip with
You can’t able read the empty excel file without header or data. It will throw error while read it self.
So you can handle this using Try catch activity
Regards
Gokul
okay… thanks
If there are 0 rows the For Each Row just won’t do anything. You don’t have to do an extra check.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.