Export EXCEL data-only report using Java SDK

65 Views

I am trying to export a report in EXCEL data-only format because I report is essentially a data only report and I don't want any formatting. How do I export the report in data-only format. Right now, it export in excel format but the output has extra blank columns.

ViewSupport viewSupport = ViewSupport.Factory.newInstance();

viewSupport.setOutputFormat(OutputFormatType.EXCEL);

viewSupport.setViewType(ViewType.BINARY);

viewSupport.setViewMode(ViewModeType.DOCUMENT);

RetrieveBinaryView retBinView = RetrieveBinaryView.Factory.newInstance();

retBinView.setViewSupport(viewSupport);

RetrieveData retrieveData = RetrieveData.Factory.newInstance();

retrieveData.setRetrieveView(retBinView);

docInfo = reportEngine.getDocumentInformation(docInfo.getDocumentReference(), null, oActions, null, retrieveData);