title: API Automation Testing : Is there any way to automate download scenario with content validation?
body: <p>I have an export to excel feature in our application.
  For which I have one scenario:</p>
  
  <ol>
  <li>Perform export to excel </li>
  <li>Validate API response status and exported excel content.</li>
  </ol>
  
  <p>With Postman, I am able to save exported excel in .xlsx format with "Send and Download" option on which later I am validating content (Column Headers and row values) manually.</p>
  
  <p>Is there any way to automate this scenario end to end through API automation?</p>
  
  <p>Currently, I am doing get operation (Karate framework) which is responding me these headers in response:</p>
  
  <ol>
  <li><p>Content-Type →application/vnd.openxmlformats-officedocument.spreadsheetml.sheet</p></li>
  <li><p>Accept-Ranges →bytes</p></li>
  </ol>
  
  <p>Body: Stream objects which are not human readable.</p>
  
  <p>Status: 200 ok</p>
  
  <p><strong>If e2e automation not possible/feasible, what should be the acceptance criteria for automation in this case than?</strong></p>