How to convert xml response for web serivce in to Excel

This might be what you're looking for.
I'm doing SOAP API's but the return is still XML.

I have a "Property Transfer" & "DataSink"
> The property Transfer will pull responses & send them to the DataSink
> The DataSink will send the values to Excel

DataSink Settings:
File: Is a template how you want the sheet to look. Can even be blank doc.
Out File: Is the file it writes to and is in the format of the template
Worksheet: Is the sheet the template uses
Start at Cell: Need I explain but be sure if you use a header in the template - then start at A2

Hope that helps
Rob

Thanke. let me try this out and get back to you

UNABLE TO RECOGNIZE OLE STREAM..am i missing something from installation or settings?

That's specific to Excel - are you using 2007/(xlsx)? If so - convert to xls - - xlsx doesn't work in SoapUI

Jasper175 wrote:
That's specific to Excel - are you using 2007/(xlsx)? If so - convert to xls - - xlsx doesn't work in SoapUI

Converting from xlsx to xls worked for me. This is helpful. Thanks.