Manipulating existing .xlsx data
Hi 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 an...
Forum Discussion
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.
It also looks like you received the same answer yesterday here: https://community.smartbear.com/t5/SoapUI-Pro/How-to-manipulate-excel-data/m-p/148188#M33762
This is going to require you to do some groovy scripting.
