i've performed various steps while integrating which i am mentioning below
step1--> first i downloaded uk.co.spudsoft.birt.emitters.excel_0.8.0.201211020842.jar and then i paste that jar in WEB INF/lib.
step2--> Then i extracted uk.co.spudsoft.birt.emitters.excel_0.8.0.201211020842.jar and took all the files from the lib folder i.e. lib/commons-codec-1.5.jar,lib/dom4j-1.6.1.jar,lib/poi-3.8-beta4-20110826.jar,lib/poi-ooxml-3.8-beta4-20110826.jar,lib/poi-ooxml-schemas-3.8-beta4-20110826.jar,lib/slf4j-api-1.6.2.jar,lib/stax-api-1.0.1.jar,lib/xmlbeans-2.3.0.jar and pasted them in WEB INF/lib.
step3--> Then i checked plugin.xml and found its content as
<?xml version="1.0" encoding="UTF-8" ?>
<?eclipse version="3.4"?>
- <plugin>
- <extension id="uk.co.spudsoft.birt.emitters.excel" name="SpudSoft BIRT Emitters" point="org.eclipse.birt.report.engine.emitters">
<emitter class="uk.co.spudsoft.birt.emitters.excel.XlsxEmitter" format="xlsx" id="uk.co.spudsoft.birt.emitters.excel.XlsxEmitter" mimeType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" pagination="page-break-pagination" />
<emitter class="uk.co.spudsoft.birt.emitters.excel.XlsEmitter" format="xls" id="uk.co.spudsoft.birt.emitters.excel.XlsEmitter" mimeType="application/vnd.ms-excel" pagination="page-break-pagination" />
</extension>
</plugin>
by which it seems that xlsxEmitter is already present there.
step4--> Earlier i was calling excel(xls) from a servlet like mentioned below
method.setPath("/birt/run?__report=abc.rptdesign&__format=xls");
response.setContentType("application/xls");
response.setHeader("Content-Disposition", "attachment; filename=XYZ Report.xls");
but my report is extrawide(more than 255 columns) so i wanted to use a XLSX emitter so i tried
method.setPath("/birt/run?__report=abc.rptdesign&__format=xlsx");
response.setContentType("application/xlsx");
response.setHeader("Content-Disposition", "attachment; filename=XYZ Report.xlsx");.
but it didn't worked.
