Forum Discussion

BMCIM's avatar
Occasional Contributor
7 years ago

Manipulating existing .xlsx data



I have a .xlsx file stored in my local directory.  I need to manipulate the cells in the spreadsheet and save.


I have been reviewing Groovy scripts but so far I have had no joy.


Can anyone help?




3 Replies

  • groovyguy's avatar
    Champion Level 1

    Groovy is going to be your best bet so you have full control over what you need to do. Outside of that, you could try using a datasource to read from the spreadsheet, groovy test step to manipulate the data however you desire, and then a data sink to write it back but at that point you might as well just write an entire groovy script to do what you want.