Print Data Row in For Each Row

Hello,

I want to print the Column1 for checking every row if it’s null or not.

But I’m getting this error.

Thank you.

good day
Can you send the excel file and the xaml file?

@Shaira_Janine_Torio could you please share your workflow?

you want to check the whole row as null or empty. Try this:

String.IsNullorEmpty(String.Join(“”,row.itemArray).Trim)

String.Join(“”,row.itemArray).Trim—> It willl join all your columns and make a One String, then you can use function String.IsNullorEmpty

1 Like

The value is null, hence the error.
It means NULL can’t be converted to type string

In log you can use, it will handle the error:

(Iif(String.IsNullOrEmpty(row(0)),"",row(0).ToString)).ToString

1 Like

@Ghazal303 @Vrushali_Gave @KanadMehta @sachinbhardwaj

Good day, this is the sample

sample.zip (19.0 KB)
pullout.xlsx (8.5 KB)
reshuffle.xlsx (8.5 KB)

Thank you