Contributions
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();6 years agoPlace ReadyAPI QuestionsReadyAPI Questions17KViews0likes0CommentsAn 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, ManaliSolved6 years agoPlace ReadyAPI QuestionsReadyAPI Questions17KViews0likes3Commentshow 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, Manali6 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.9KViews0likes1CommentRe: 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, Manali6 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.7KViews0likes1CommentRe: 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 - Manali6 years agoPlace ReadyAPI QuestionsReadyAPI Questions15KViews0likes0CommentsRe: 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, Manali6 years agoPlace ReadyAPI QuestionsReadyAPI Questions15KViews0likes3CommentsRe: 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, Manali6 years agoPlace ReadyAPI QuestionsReadyAPI Questions15KViews0likes7CommentsRe: 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, Manali6 years agoPlace ReadyAPI QuestionsReadyAPI Questions15KViews0likes0Comments