Creating/Updating excel sheets with groovy
Hi All,
How do i create/update an excel sheet from within a groovy without using Datasink/Datasource steps of SoapUI-Pro?
There are some limitations of using datasink/source steps with excel as an option.
My requirement is as follows:
My project creates Billing Account Details. I need the same excel sheet to be updated every time i run different automated test cases in my Soapui-Pro. Alos, one testcase may generate one BAN(Billing Acc Num) and the other may generate 2-3 BANs. But this is not possible as we have to manually configure the starting row in datasink excel configuration.
But i hope there's a work around for this if we use groovy to do the same.
Please let me know how this can be done.
Regards
Mallik
How do i create/update an excel sheet from within a groovy without using Datasink/Datasource steps of SoapUI-Pro?
There are some limitations of using datasink/source steps with excel as an option.
My requirement is as follows:
My project creates Billing Account Details. I need the same excel sheet to be updated every time i run different automated test cases in my Soapui-Pro. Alos, one testcase may generate one BAN(Billing Acc Num) and the other may generate 2-3 BANs. But this is not possible as we have to manually configure the starting row in datasink excel configuration.
But i hope there's a work around for this if we use groovy to do the same.
Please let me know how this can be done.
Regards
Mallik
