Manipulating existing .xlsx data

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.