About how check blank excel file have blank row

how can I check if my excel have blank row, I need check start from row 6, thanks in advance


Hi @Liwq

1.Use Excel Application Scope Activities.
2.Use Read Range Activities.
3.Create DataTable variable
4.Use ForEachRow Activities to iterate in the loop.
5.Use If Activites to check if it is empty or not.

Sample of If condition.
If(row(index or column name).ToString = “”)
or you can use string.empty.

If you want to check starting in row 6 you can use a counter and increment it thru the loop.

cheers :smiley:
Happy learnig



1 Like

Hi pattyricarte, I have another question, when I use header_DT.ElementAt(vIndex).ToString to check the excel column,header_DT is IEnumberable variable, when the column is blank, it will throw an error, do you know why, thanks in advance.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.