Tool to write the Response data to external excel file

ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

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.

Comments

  • benken_parasoftbenken_parasoft Posts: 519 ✭✭✭

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

  • ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

    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_parasoftbenken_parasoft Posts: 519 ✭✭✭

    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

  • ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

    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..

  • ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

    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

  • ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

    Any option would be added as feature??

  • jakubiakjakubiak Posts: 360 admin

    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.

  • ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

    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.

  • jakubiakjakubiak Posts: 360 admin

    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.

  • ParasofttoudayaParasofttoudaya Posts: 199 ✭✭

    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.

  • jeremygorejeremygore Posts: 1

    Hi, you can try ZetExcel

    Jeremy Gore

  • peterfergusonpeterferguson Posts: 1

    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

Sign In or Register to comment.