how can I check if my excel have blank row, I need check start from row 6, thanks in advance
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.
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.