Forum Discussion

maxrussell's avatar
maxrussell
Contributor
4 years ago

Excel data source read by column

In the Data Source Options dialogue, settings, Start Row and End Row can be specified. However my data is a time series, from left to right column. Can a start and end column be configured as data so...
column
datasource
  • HimanshuTayal's avatar
    HimanshuTayal
    4 years ago

    maxrussell :

     

    Not sure that you can achieve this with DataSource, but yes you can write your custom code. In order to use Groovy Script you can use Groovy test step ad write your code no further installation is required as in ReadyAPI groovy Libraries are pre-installed.

     

    Let me know if you need more help

     

maxrussell's avatar
maxrussell
Contributor
4 years ago

I wish to do this in order to validate cell content in the sheet (from left to right) against a JSON response. If it is possible to read the contents in for this, without the datasource step, that might be useful

  • richie's avatar
    richie
    Community Hero
    4 years ago
    Hey maxrussell,

    I didnt try and answer this post cos im not best placed to answer this....other people will know more than i do about this.
    ReadyAPI! Datasource steps use rows not columns right?
    I think you have a choice....use groovy step to source your spreadsheet data (rather than a Datasource step) OR, could you not use the transpose excel function when copying and pasting as this transposes vertical to horizontal and horizontal to vertical (so it transposes columns to rows and rows to columns)
    If you transpose you could then use the datasource step, right?

    Cheers,

    Rich
    • maxrussell's avatar
      maxrussell
      Contributor
      4 years ago

      I'm able to work with the data if/when transposed, although this adds an extra step into our automation.

       

      I did look at several methods of working with excel, in Groovy, but these all seemed to require extra libraries for Groovy - which I don't know how to install into the ReadyAPI implementation.

      • HimanshuTayal's avatar
        HimanshuTayal
        Community Hero
        4 years ago

        maxrussell :

         

        Not sure that you can achieve this with DataSource, but yes you can write your custom code. In order to use Groovy Script you can use Groovy test step ad write your code no further installation is required as in ReadyAPI groovy Libraries are pre-installed.

         

        Let me know if you need more help