How can I export Oracle BI publisher report in real Excel format(not .xls, but content is html)?

Question

Summary

Content

I use this java code to export  BI publisher report in Excel format, I would like to get real Excel file, but I got .xls that content is html.

ReportRequest reportRequest = new ReportRequest();

reportRequest.setReportAbsolutePath("/XXXX/XXXX/XXXXXPROD/REPORT/HPTGAT008R20 - xxxxxxxxxxxxxxxx.xdo");

reportRequest.setAttributeTemplate(template);

reportRequest.setAttributeFormat("excel");

reportRequest.setAttributeLocale("en-US");

reportRequest.setSizeOfDataChunkDownload(-1);

ParamNameValues paramNameValues = new ParamNameValues();

paramNameValues.setListOfParamNameValues(arrayOfParamNameValue);

reportRequest.setParameterNameValues(paramNameValues);

ReportResponse repResponse = new ReportResponse();

repResponse = reportService.runReport(reportRequest, username, password);

byte[] baReport = repResponse.getReportBytes();

FileOutputStream fio = new FileOutputStream("C:\TestReportForamt.xls");

fio.write(baReport);

fio.close();

Could you advise me or provide sample java code to export BI publisher report in real Excel format?

[Deleted User] · Answer

@ManikantaRendla You are posting into a thread that's almost 7 years old. Please open your own thread and state your question and issue clearly and with all pertinent details. Full version number, full product name, screenshots, code examples, error messages if applicable etc.

This way you can manage incoming replies which is not possible in an existing, abandoned, thread.

ManikantaRendla · Answer

Dear,

Did you get any solution for the above problem..?

Could you please let me know..!

Carlos Carvalho · Answer

BTW, are you able to successfully run it in soapUI?