Hi friends,
When using an Excel sheet for input variables,
in one row I need the variables to be null and in some other row I need the same variable to contain some value.
For example, if the excel sheet contains data as follows
eg: A B C D
Row 1: 4 0 1 3
Row 2: 1 2 3

When second row is getting executed, A is still having the value 4 where I need it to be null.

Is there a solution for this other than setting every variable to nothing or null at the start of each iteration? setting each variable to null is some what tedious for me because I have more than 100 variables in my excel sheet. This is very urgent for me. Please respond ASAP if u have an answer. Thanks in advance.

Reading your post, i felt that you don't initialize your variable correctly. Below may help:

load your datatable
dim rowa, rowb, rowc, rowd, totrowcount
totrowcount = get your excelsheet row count
for i = 1 to totrowcount
rowa = get your data from row a
rowb = get your data from row b
rowc = get your data from row c
rowd = get your data from row d
do your stuff
set current row to next row
Next

I am using similar code. I am searching for a method which will be like "Remove.All". I don't remember exactly.
Anyways, Thank you.

Interesting! share me the trick after you solve the problem.

In the mean time, can you attach you code and datatable?

Try to set your variable to "Null".

load your datatable
dim rowa, rowb, rowc, rowd, totrowcount
totrowcount = get your excelsheet row count
for i = 1 to totrowcount
if (i = your row want to be null) then
rowa = Null
rowb = Null
rowc = Null
rowd = Null
Else
rowa = get your data from row a
rowb = get your data from row b
rowc = get your data from row c
rowd = get your data from row d

End IF
do your stuff
set current row to next row
Next

Hi learqtptesting,

Thank you for the reply and time. But I dont want to set each variable to null individually. But surely I will post the solution if I find any.. I am still waiting for the solution..

Looking forward to see the solution.


Curiousity:
Since you design data and list them in excel,

why don't want your data? Can you just leave the cell blank for the intended row, row 2? or why can you just ignore to data in the row (since you don't need them) and do your stuff you would like to? then do normal stuff at other intended row.