testExec.setStateValue("Read Rows from Excel File_RowNum","1");
Please send your suggestions.
I'm sure I'm over simplifying, but why not just create a new tab in your spreadsheet and copy the first row there so there is always just a single row?
Did Josh's recommendation help you out?
I did it in a different manner - Kept this dataset step in a subprocess and it worked. Thanks anyway for offering help.