Forum Discussion

mesg2anil's avatar
mesg2anil
Regular Contributor
14 years ago

Using Array to get Excel data

Hi, I'm trying to get values (data) from excel, after using if and for loop to get rows and columns details, I'm trying to put the data to an array and then use the array to input the data from...
pradeep_kamatha's avatar
pradeep_kamatha
Contributor
13 years ago
Hi Anil,

I have got a similar requirement, but I need to store 9th and 10th column from CSV file data into Arrays. I was able to get the Column data, but not able to store in an Array. Kindly help me on this.






var lResultDriver = DDT.CSVDriver(lFullOutputFileName);  


            //var lResultArray = new Array();


           


       


           Var ColCount = 9;


           while(!lResultDriver.EOF())


           {


                if(ColCount ==9)


                {


                 Log.Message(lResultDriver.Value(10) + "--> "+ aqConvert.VarToStr(lResultDriver.Value(9)));


                


                }


                else


                {


                 Log.Message("error");


                }


             


             


                //Log.Message(lResultDriver.Value(10) + "--> "+ aqConvert.VarToStr(lResultDriver.Value(9)));


                lResultDriver.Next();


                ColCount= ColCount+1;


          }


          


          DDT.CloseDriver(lResultDriver.Name);