09-13-2010, 09:27 PM
I had the same issue. Never could figure it out. What I found was that it would only run the same number of rows you had in the design environment data tab. If I had 3 row there regardless of how many I imported, it would only run 3 rows.
I ended up doing the following.
I ended up doing the following.
Code:
Dim x, rowcount
rowcount = DataTable.GetSheet("Sheet1").GetRowCount
'set row and get data
For x = 1 to rowcount
DataTable.SetCurrentRow(x)
'do your processing here
Next