We are reading a very data intensive Excel file and recieve an error on certain conditions.
Here is a simple example with a test.xls file (has to be xls).
Dim Workbook As New Workbook("c:\test.xls")<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Dim Ws As Worksheet = Workbook.Worksheets(0)
Dim RowCount As Int32 = 0
For RowCount = 0 To 1
If Ws.Cells.GetCell(RowCount, 0).Value IsNot Nothing Or Ws.Cells.GetCell(RowCount,1).Value IsNot Nothing Then
The error occurs if the contents of the first row is deleted or pasted over.
How do we test for a null value?
Thanks for your excellent Support,
Current Customer Cluehawk.