Read Column Activity fails to read value when there is only one value in the column
Steps to reproduce:
Create a workbook as shown below two variations:
Following is the activity I’ve used :-
Note: I’m reading from cell A2
When read column is executed under variation 1 above; we get the following result -
When executed under variation 2; following is the result -
When Executed under Variation 3; following is the result -
For variation 1, the result is correct.
For Variation 2, the items count is correct but there are no item values present.
For variation 3, it’s reading the cell A1 which is not at all required.
Following code is used for the MessageBox:
"ItemsCount:" & enumColValues.Count.ToString & vbcrlf & String.Join(vbCrlf,enumColValues.ToArray)