Forum Discussion

abdul_rp's avatar
abdul_rp
Contributor
13 years ago

Invalid Use of Null error while reading data from an Excel sheet

Hi, I am getting an error saying "Invalid Use of Null" while reading data from Excel sheet, I am getting this error for the Cell's fromat type Number, whereas I am able to read the data from ot...
ekiza23's avatar
ekiza23
Contributor
13 years ago
I had a similar problem with Excel.



I do not know if it is the same, but I fixed it by checking if the returned value was null (IsNull in vbscript - http://www.w3schools.com/vbscript/func_isnull.asp) and then assigning a default value for empty cells.



Also, can you attach an example of excel file that causes this problem?