The Java API supports the running of Cognos Reports but the Output Format for the report is limited to the enumeration types documented in the CognosOutputFormat class - which is CSV, PDF, XLWA, HTML, XML.
To be able to run a report via the API into Excel format I believe there is a need to be able to specify the 'spreadsheetML' format to Cognos via the CognosOutputFormat class. It might also be useful to provide a way of NOT specifying any output format at all in the API call and letting the default format specified in the report in Cognos Portal be provided.
Please add this capability.
The business use-case is to have a have an enduring record of the state of data at the point a business user provides an 'Attestation' - an Attestation being a Workflow Action the user performs. This requirement is being met by having a custom workflow operation that runs a Cognos report to gather all the relevant data together and add the output of the report as an Attachment file to the object the workflow is being performed on - thereby retaining a record of the state of data at the point of the Attestation. However, there is a strong preference fr this report to be in Excel format - which is not currently possible.
Do not place IBM confidential, company confidential, or personal information into any field.