Hi All,
I am trying to find the Empty cells in few columns of Excel file and Replace with NA or 0. Here if try to find other Values it is working fine but if pass " " in find field it is not working
trying below activties.Please let me know if I am passing Null or Empty value cell correctly.
Have you tried leaving the value field blank when you want to search empty cell values? Try it and see.
Alternatively, you can first use read range activity to read excel data in datatable, then replace values in datatable and write back datatable to the excel. Ways to find and replace in datatable is in below post.
Hope this helps.
@sonaliaggarwal47 Thank you for the response.
Yes i tried, but for blank value getting this error
Hmm, I thought so.
In that case, I think implementing via other approach that I shared would be more better.
In the value field try Type.Missing ..that should replace the empty cells
The above should work..if not in below thread you can find a macro
Cheers
@Anil_G Thank you for the response,
Still it is not writing anything giving empty cell only.
1 Like
- Excel Process Scope
-
- Use Excel File
-
-
- Read Range (so you have a datatable and can get the column names)
-
-
-
- For Each Excel Row
-
-
-
-
- For Each column
-
-
-
-
-
-
- If current column isnullorempty, assign “NA”
-
-
-
Expression in IF condition: String.IsNullOrEmpty(CurrentRow(currentDataColumn.ColumnName).ToString)
Expression in Assign Save to: CurrentRow(currentDataColumn.ColumnName)