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.
You would need to script this. I recommend using the Apache POI library: https://poi.apache.org/spreadsheet/how-to.html
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.
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
using this thread we would be able to generate the whole response. Not the specific one.
I need it like below.
Hope you understand the requirement..
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
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..
Any option would be added as feature??
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.
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.
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.
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.
Hi, you can try ZetExcel
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