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 Robert,
Thank you for replying!
Other than getting the data from excel and inputing it into application, I was also trying to do some action based on rows I have in excel sheet, for example...
Excel Sheet data...
Name DOB Address1 City 'This is header section
Anil 10/10/2000 # 1 Bengaluru '1st row data
Robert 1/1/2000 # 5 US '2nd row data
Now, if I have only 1st row in the excel sheet, I want to do some action in the script else if I have 2nd row in the excel sheet i want to do other steps in the script. In my code above I gave "If i > 1" that is excluding header, I was controlling the data input to application. In my code if I write
If i = 2 then
<do this action>
elseif i > 2 then 'here it will be row 3 and above
<do this action>
End If
How to do that using DDT.Driver? Could you please help me in this regard? I'm writting the code in VB.
Thank you for replying!
Other than getting the data from excel and inputing it into application, I was also trying to do some action based on rows I have in excel sheet, for example...
Excel Sheet data...
Name DOB Address1 City 'This is header section
Anil 10/10/2000 # 1 Bengaluru '1st row data
Robert 1/1/2000 # 5 US '2nd row data
Now, if I have only 1st row in the excel sheet, I want to do some action in the script else if I have 2nd row in the excel sheet i want to do other steps in the script. In my code above I gave "If i > 1" that is excluding header, I was controlling the data input to application. In my code if I write
If i = 2 then
<do this action>
elseif i > 2 then 'here it will be row 3 and above
<do this action>
End If
How to do that using DDT.Driver? Could you please help me in this regard? I'm writting the code in VB.