Forum Discussion

seafalcon's avatar
seafalcon
Contributor
14 years ago

Run time error when using ACD driver to access an Excel File (Office2007 installed )

 Why Microsoft Jscript runtime error thrown? The excel file is pretty standard..No clue... /////////////////////////////////Code as below/////////////////////////////////////////////////...
seafalcon's avatar
seafalcon
Contributor
14 years ago

One more thing, if the Ts like this, it's executable without exception



for(i = 0; i < DDT["CurrentDriver"]["ColumnCount"]; i++) 

    Log.Message(DDT["CurrentDriver"]["ColumnName"](i) + ": " + aqConvert.VarToStr(DDT["CurrentDriver"]["Value"](i)));

  



However, if I input an extra line between, it will throw exception.. why? I am not a VBscript master.. In java, this shouldn't throw any exception.. I am beat!




for(i = 0; i < DDT["CurrentDriver"]["ColumnCount"]; i++) 





    Log.Message(DDT["CurrentDriver"]["ColumnName"](i) + ": " + aqConvert.VarToStr(DDT["CurrentDriver"]["Value"](i)));