ContributionsMost RecentMost LikesSolutionsRe: how to send report through email in ReadyAPI Hi, Is it possible to attach a report or any other attachments in the Send Mail test step in readyAPI new versions? in 2.2 it was not. regards, Manali Re: An error occurred [Your InputStream was neither an OLE2 stream, nor an OOXML stream] 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(); 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 SolvedRe: Day 1 - API Testing vs. UI Testing Happy to be part of this event, We are automating Rest API calls for angular nodejs Application how to write api response into xlsx file readyapi Hi, I want to save/write response received from an Rest API as .xlsx. Content-type application/vnd.ms-excel content disposition - attachment;filename=export.xlsx Can someone help to read the response and convert into proper xlsx file. regards, Manali Re: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue() Radford Hi, Yes I do restart readyAPI after change in EXT folder. I also had same question that the ooxml-schemas-1.4.jar file replaces poi-ooxml-schemas4.0.1.jar or sits along side it? tried both options but did not work either. Not sure if i am missing somthing trivial. If nothing works I might try earlier version but not the best choice still. regards, Manali Re: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue() avidCoder I have latest POI 4.0.1 and ooxml-schemas-1.4.jarso want the solution based on that. If we have any known technical limitation then I will try out withPOI-3.14 or POI 3.16 andooxml-schemas-1.3.jar as suggested by you. Plz share if u have faced issue with latest one. thx - Manali Re: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue() Radford As mentioned in earlier post I have usedooxml-schemas-1.4.jar but was getting same error. Please refer screenshot of the ext folder contains jar files. regards, Manali Re: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue() even withooxml-schemas-1.3.jar added to ext folder giving same error. Can u please chk the screenshot provided and suggest if any jar missing or need to remove? regards, Manali Re: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue() Hi, I tried by addingooxml-schemas-1.4.jar file into ext folder but getting same error - PFA: screenshot of ext folder jars. regards, Manali