Ask a Question

An error occurred [Your InputStream was neither an OLE2 stream, nor an OOXML stream]

SOLVED
mkajale2
Occasional Contributor

An error occurred [Your InputStream was neither an OLE2 stream, nor an OOXML stream]

Hi,

 

Steps - 

1. Read response of API and write into XLSX file  - API response content type is ms-excel content disposition as app/filename

2.Read XLSX and coompare with expected xlsx file

 

While reading the XLSX which I cretaed in step 1 it is giving me error as below- 

 

ERROR:An error occurred [Your InputStream was neither an OLE2 stream, nor an OOXML stream], see error log for details

 

can someone help?

 

regards,

Manali

3 REPLIES 3
TanyaYatskovska
SmartBear Alumni (Retired)

Hi @mkajale2,

 

How do you save to response to an XLSX file? Groovy script? Please share it with us - I think it will help the Community understand the cause of the error.

 

BTW, I suppose that this request duplicates this one. Please avoid creating duplicated posts in the future.

https://community.smartbear.com/t5/SoapUI-Pro/how-to-write-api-response-into-xlsx-file-readyapi/m-p/...

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager



TanyaYatskovska
SmartBear Alumni (Retired)

Hi @mkajale2,

 

Are you still looking for the solution? If you've found the one, please share it here.

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager



mkajale2
Occasional Contributor

Hi,

 

Reading response at run time resolved the issue. 

 

//read raw response at run time  
def rawResponse = context.httpResponse.getRawResponseBody();
InputStream inputStream = new ByteArrayInputStream(rawResponse);

// write Response to excel file
def file = new FileOutputStream(ActualExcelFilePath)
def out = new BufferedOutputStream(file)
int read = 0;
byte[] bytes = new byte[1024];
while ((read = inputStream.read(bytes)) != -1) {
out.write(bytes, 0, read);
}
out.close();

cancel
Showing results for 
Search instead for 
Did you mean: