We use the Cognos SDK as the basis for an integration test suite.
The testcases login with users in the expected role, then execute the reports in their various output formats (HTML, PDF, Excel, Excel Data, etc) , and finally execute a number of assertions against the output files (we don't test PDF output for a number of reasons) .
For Excel, we use Apache POI to read the spreadsheets and iterate through the sheets, rows, and cells.
------------------------------
Denilson Nastacio
------------------------------