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.