mkajale2
Occasional Contributor
Joined 11 years ago
User Profile
User Widgets
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();18KViews0likes0CommentsAn 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, ManaliSolved18KViews0likes3Commentshow 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, Manali3KViews0likes1CommentRe: 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, Manali1.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.jar so want the solution based on that. If we have any known technical limitation then I will try out with POI-3.14 or POI 3.16 and ooxml-schemas-1.3.jar as suggested by you. Plz share if u have faced issue with latest one. thx - Manali15KViews0likes0CommentsRe: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue()
Radford As mentioned in earlier post I have used ooxml-schemas-1.4.jar but was getting same error. Please refer screenshot of the ext folder contains jar files. regards, Manali15KViews0likes3CommentsRe: NoClassDefFoundError: while reading XLSX file using XSSF cls for getCellType() /getStringCellValue()
even with ooxml-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, Manali15KViews0likes7Comments