Forum Discussion

roja1's avatar
roja1
Contributor
5 years ago

Getting corrupted excel file created through groovy script

Hi ,   I'm using below script to create a report of my test execution. Since some of my response body has huge size , which cannot be accommodated into an excel cell I have used a logic to just wri...
nmrao's avatar
nmrao
Champion Level 3
5 years ago
Not sure why the response is required in the report which any way gets saved by the tool if you run the tests from command line.

Like you said, response is too big, what is the use for it? I believe it doesn't even make any difference by writing even small XML.

Just think of what do you lose by not writing response. Instead consider having as many assertions possible to ensure test is passed.
  • roja1's avatar
    roja1
    Contributor
    5 years ago

    Hi nmrao ,

     

    Thanks for your reply. As per the requirements, we need to get the response in the report.

     

    • HimanshuTayal's avatar
      HimanshuTayal
      Community Hero
      5 years ago

      roja1 :

       

      What i would suggest is store the request and response into txt files and in your Excel sheet write the link of that excel file.

       

      This way your excel file will look more neat 🙂

      • roja1's avatar
        roja1
        Contributor
        5 years ago

        Hi HimanshuTayal ,

         

        Thanks for your reply. I'm not saving my response manually. We need to do this through the groovy script