Test method proofofconceptgoogle.CodedUITest1.CodedUITestMethod1 threw exception:
System.NullReferenceException: Object reference not set to an instance of an object.


Dim excelarray() As String
Dim arrayindex As Integer
arrayindex = 1
For index = 1 To xlsColsCount
xlsCell = xlsSheet.Cells.Item(2, index)
If xlsCell.Value Is Nothing Then
MsgBox("Blank")
Else
TestVal = xlsCell.Value2.ToString()
MsgBox(TestVal)
excelarray(arrayindex) = TestVal


arrayindex = arrayindex + 1
End If

Next
xlsWB.Close(True)