Service Virtualization

Expand all | Collapse all

Is there a way we can make the excel dataset to read from the 1st row even if the dataset is read subsequently

Jump to Best Answer
  • 1.  Is there a way we can make the excel dataset to read from the 1st row even if the dataset is read subsequently

    Posted 05-10-2016 05:45 PM

    I  want to read the same 1st row in an excel dataset everytime I come back to the step having the dataset. Is anybody aware how to do that? I wrote the following javascript but that also did not work.

    testExec.setStateValue("Read Rows from Excel File_RowNum","1");

     

     

    Please send your suggestions.



  • 2.  Re: Is there a way we can make the excel dataset to read from the 1st row even if the dataset is read subsequently

    Posted 05-10-2016 08:10 PM

    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?



  • 3.  Re: Is there a way we can make the excel dataset to read from the 1st row even if the dataset is read subsequently

    Posted 01-17-2017 02:56 PM

    Rahul,

     

    Did Josh's recommendation help you out?



  • 4.  Re: Is there a way we can make the excel dataset to read from the 1st row even if the dataset is read subsequently
    Best Answer

    Posted 01-30-2017 01:05 PM

    I did it in a different  manner - Kept this dataset step in a subprocess and it worked. Thanks anyway for offering help.