I have an Excel spreadsheet with two columns.
- The individual cells of the columns are not always filled. The content is always numeric (double).
I write these values into a DataTable.
The two columns are to be transferred to a second DataTable subject to two conditions.
Condition 1: Column 1 is not empty and column 2 is empty.
I tried the following:
In a For Each Row activity an If statement with the condition:
Record(0) >= 0 and Record(1) = IsEmpty
Then Message Box (“Bla”)
Else Message Box (“Blub”)
Unfortunately, the condition does not work. Is there a solution?
Translated with www.DeepL.com/Translator