06-16-2011, 07:06 PM
Thanks Manish,
I was using DataTable.GetSheet(dtGlobalSheet).SetCurrentRow but then changed to DataTable.GetSheet(dtGlobalSheet).SetCurrentRow(i) later and got the results. However I had to make changes to the inner loop also the same way and made it DataTable.GetSheet(dtGlobalSheet).SetCurrentRow(j). Now it works fine.
I was using DataTable.GetSheet(dtGlobalSheet).SetCurrentRow but then changed to DataTable.GetSheet(dtGlobalSheet).SetCurrentRow(i) later and got the results. However I had to make changes to the inner loop also the same way and made it DataTable.GetSheet(dtGlobalSheet).SetCurrentRow(j). Now it works fine.