Service Virtualization

  • Private Community
 View Only

  • 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 May 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 May 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 Jan 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 Jan 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.