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...
TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
13 years ago

Hi Abdul,


 


Try using the aqConvert.VarToStr method to convert data from a cell:




 Set DataDriver = DDT.ExcelDriver("C:\\Scenario.xls","Scenario1")


 While Not DataDriver.EOF


 MsgBox(aqConvert.VarToStr(DataDriver.Value("INPUTDATA")))


 DataDriver.Next


 Wend