Tool to write the Response data to external excel file

Parasofttoudaya

Hi Team,

I have encountered a situation where i have to write the data to external excel file. I have tried to use write file option, still that would not be a solution as my data should go to external file.

benken_parasoft

You would need to script this. I recommend using the Apache POI library: https://poi.apache.org/spreadsheet/how-to.html

Parasofttoudaya

SOAP UI provides writeData, Why dont we have any other tool?

This feature is majorly required from all organization. Any parasoft marketplace tools??

Scripting makes us to work more when there is a change in requirement.. Anything inbuild tools feature is appreciatable.

Regards
Udaya

benken_parasoft

There may be some other options available which were discussed in this other thread: https://forums.parasoft.com/discussion/2816/how-to-extract-fields-from-response-message-and-write-to-file

Parasofttoudaya

using this thread we would be able to generate the whole response. Not the specific one.

I need it like below.
UserName|Password|keyStrokeToken|Key|

Hope you understand the requirement..

OmarR

The following post may also help: https://forums.parasoft.com/discussion/2698/how-to-create-csv-files-editable-in-microsoft-excel-from-data-extracted-from-tests

Parasofttoudaya

Hi Omar,

How are you, Thanks for the response , it looks good..

But required data to be collected from multiple responses ;( is there any way to achieve it??

Any help would be appreciatable to achieve it..

Regards
Udaya

Parasofttoudaya

Any option would be added as feature??

jakubiak

If you are asking about writing directly to an Excel spreadsheet - this is not on the roadmap at this time, since writing to a CSV file is simple and CSV files can be easily opened in Excel.

Parasofttoudaya

CSV vs Excel would not be a big deal, I am fine with csv file..
is there any option to collect the data from multiple response and put it in csv file? like we have that option in SOAP UI & CA LISA.

jakubiak

Well you could use a data bank to extract data from each response, and then use an Extension Tool to put the data together into CSV content. You could then return the CSV content from your Extension Tool, and chain a Write File tool to the Extension Tool to write out the CSV file.

Parasofttoudaya

You mean create csv and put the collective data bank content to csv file? I was expecting parasoft feature to do so..

you can ask for all your clients whether this feature is in need, offcourse every one is in need. Then you can add as a feature.

jeremygore

Hi, you can try ZetExcel

Jeremy Gore

peterferguson

As for me i always take advantage of ZetExcel to write the data to external excel file. and also to generate excel file on c #. you can check it for yourself
Thanks

Peter Ferguson

romankris

Hope this will help you...c# excel export