Print Data Row in For Each Row

Help Studio
,
1

Hello,

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

But I’m getting this error.

prob
prob1322×750 43.9 KB

Thank you.

2

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

3

@Shaira_Janine_Torio could you please share your workflow?

4

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
5

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
7

@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