newbiexiii
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Reading values from excel file
My AUT exports excel files which contains dates and strings. I am trying to read the exported excel file but dates are read as encoded. For instance, the excel has a column named Date and date format is 8/25/2016 11:13:52 AM but when I try to read this value with Excel object, I get _x0038__x002F_25_x002F_2016_x0020_11:13:52_x0020_AM How can I decode this to get the correct date format? Code used to open and read excel file var sheet = Excel.Open(filename).SheetByIndex(0); sheet.Cell(7,2).Value;687Views0likes4CommentsRe: Loop/iterate over dictionary
It enters the loop but when it try to access the values it shows up as undefined var dict = new ActiveXObject("Scripting.Dictionary"); dict.add("a",1); dict.add("b","2"); dict.add("c","3"); var keys = dict.Keys(); Log.Message("the keys are "+keys[0]); -----> prints undefined var typeIs = typeof keys; Log.Message("the type of keys is "+typeIs) -----------> prints undefined for(var i=0; i<dict.Count; i++){ Log.Message("inside for loop"); Log.Message("key is "+keys[i]+" and value is "+sessionsData[keys[i]]); ---------> prints key is undefined and value is undefined }1.3KViews0likes1CommentLoop/iterate over dictionary
I created a dictionary as follows and would like to loop over it and perform some actions. var dict = new ActiveXObject("Scripting.Dictionary"); dict.add("a",1); dict.add("b",2); dict.add("c",3); for (var key in dict){ Log.message("key is "+key+" and value is "+dict[key]) } But the program does not enter the loop. How can i iterate over the dictionary in Testcomplete using Jscript?Solved1.6KViews0likes4Comments