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...
Forum Discussion
Hi Margaret / Robert,
Thank you for replying!! :)
The code which I pasted above at top, I want to use array in that code to collect the data from excel. Later Robert suggested me to use DDT.Driver, the code which Robert gave me, I could use that, but... again I had a question about how to control the rows in that code which Robert gave me.
I need two suggestions here...
1. If I use my code which I pasted at top, in that code if I want to use array to collect all the excel data, how to do that in my existing code? OR
2. If I use the code which Robert sent, in that code "MyDDTObject" is acting like an array, also I want to do below...
If rowcount = 1 then
<perform action1>
elseif rowcount = 2 then
<perform action2>
End if
how to use above mentioned example in the code which Robert sent?
Thank you for replying!! :)
The code which I pasted above at top, I want to use array in that code to collect the data from excel. Later Robert suggested me to use DDT.Driver, the code which Robert gave me, I could use that, but... again I had a question about how to control the rows in that code which Robert gave me.
I need two suggestions here...
1. If I use my code which I pasted at top, in that code if I want to use array to collect all the excel data, how to do that in my existing code? OR
2. If I use the code which Robert sent, in that code "MyDDTObject" is acting like an array, also I want to do below...
If rowcount = 1 then
<perform action1>
elseif rowcount = 2 then
<perform action2>
End if
how to use above mentioned example in the code which Robert sent?