Vb.net: Check if an Excel Cell is Empty

Asked Apr 14 '17 at 14:22

Active Apr 14 '17 at 14:33

Viewed 13 times

I have the following code which given a cellrow and cellcolumn returns the value in a given Excel worksheet:

Public Function getCellValue(cellRow, cellColumn) As String
    Dim aString As String
    Dim xRng As Excel.Range
    Dim val As Object

    xRng = CType(xlSheet.Cells(cellRow, cellColumn), Excel.Range)
    val = xRng.Value()
    If val Is DBNull.Value Then 'thought this would work
        aString = "Null"
    Else
        aString = val.ToString
    End If
    Return aString
End Function

My issue is sometimes the cell is going to be empty. I thought the DBNull.Value check would work but it gives me an error. Any and all help is much appreciated!

ERROR: An unhandled exception of type 'System.NullReferenceException' occurred in Tutorial.exe Additional information: Object reference not set to an instance of an object.`

EDIT: I know what a nullreferenceexception is, I am just looking for a way to check if an excel value IS null

edited Apr 14 '17 at 14:33

asked Apr 14 '17 at 14:22

Bob

1,344
3
29
63

`t gives me an error` Is the error a secret? Would you go to the doctor and say "it hurts" and expect a good diagnosis? – Ňɏssa Pøngjǣrdenlarp Apr 14 '17 at 14:25
@Plutonix error added – Bob Apr 14 '17 at 14:30
@Plutonix the weirdest thing happened when I ctrl+f'd "Excel" in the question you said has an answer to this.. nothing popped up. – Bob Apr 14 '17 at 14:34
1

Excel has nothing to do with it; a null reference is a null reference. If you cant be bothered to read it, find the section about **DBNull is not Nothing**. – Ňɏssa Pøngjǣrdenlarp Apr 14 '17 at 14:41

Vb.net: Check if an Excel Cell is Empty

0 Answers0