Integrating Birt 2.5.1 with Apache POI ??

kiranv

I want to integrate my Birt report with Apache POI. Like after generating report in the desired format (doc/ppt/xls) i want to further manipulate and modify the report runtime for the particular format.

So say i render report as XLS then i would want to have access to the excel sheet or if it is a PPT then to the particular slide.

Has anyone done something like this???

Here is an example of what i want exactly.

My working source code to generate the report is-

---

ByteArrayOutputStream reportOutput = new ByteArrayOutputStream();
IReportEngine birtReportEngine = BirtEngine.getBirtEngine();
IReportRunnable design = null;
String reportPath==getContext().getServletContext().getRealPath("/reports")+ "/reportchart.rptdesign";
design = birtReportEngine.openReportDesign(reportPath);

IRunAndRenderTask task = birtReportEngine.createRunAndRenderTask(design);



IRenderOption options = new RenderOption();
options.setOutputFormat(outputFormat);//outputFormat="xls","ppt","doc"
options.setOutputStream(reportOutput);
Map appContext = task.getAppContext();
appContext.put(EngineConstants.APPCONTEXT_CLASSLOADER_KEY,
GenerateReportActionBean.class.getClassLoader());
task.setAppContext(appContext);
task.setRenderOption(options);
task.run();
task.close();

---

Now the reportOutput object has the report in the desired format. Say i know it is an excel file.
So i want to access the sheet at runtime with something like

HSSFWorkbook wb = new HSSFWorkbook(); //Apache POI classes
wb.write(reportOutput);

now i can access the sheet/row/column/cell of the report by say
Sheet sheet= wb.getSheet(0) ..or something like this..

Has anyone integrated Apache POI with BIRT 2.5.1.

If yes, then any kind of help is really appreciated.

kiranv

Got it working..

here is the code.

Define an output folder say in the temp. directory of ur local HDD-

String outputFolderPath="C:/temp/output/WebReport.xls";

For a web application you can create a folder WEB-INF and then access it from servlet context.

Assume the generated report is in xls format-

//Save the xls file in the output folder
OutputStream outputStream = new FileOutputStream (outputFolderPath);
reportOutput.writeTo(outputStream);

HSSFWorkbook wb=new HSSFWorkbook( new FileInputStream(outputFolderPath));

Now u have access to the generated workbook.
U can manipulate the workbook using all Apache POI APIs like say
wb.setSheetName(0, "Hierarchy");

Finally again store the xls in a ByteArrayOutPutStream

reportOutput = new ByteArrayOutputStream();
wb.write(reportOutput);

Thats it done..
Similarly u can access a DOC/PPT report generated from Birt in a J2EE web application