nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

IReportEngine with SpudSoft Excel emitter Margin Constant Error

pgtips · 2013-06-05T12:54:34+00:00

Hello, Using birt runtime 4.2.2 in a Spring Web framework setup. Spudsoft Birt emitter excel 0.8.0.201306042016 Spudsoft jar and required jars in WEB-INF/lib folder. Relevant code is: RenderOption options = new…

pgtips

Hello,<br />
<br />
Using birt runtime 4.2.2 in a Spring Web framework setup. Spudsoft Birt emitter excel 0.8.0.201306042016<br />
<br />
Spudsoft jar and required jars in WEB-INF/lib folder.<br />
<br />
Relevant code is:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
RenderOption options = new RenderOption();
options.setOption("ExcelEmitter.SingleSheet", true);
options.setOption("ExcelEmitter.DisplayGridLines", true);
options.setOption("ExcelEmitter.DisplayRowColHeadings", true);
options.setOption("ExcelEmitter.DisplayZeros", true);
options.setOption(ExcelEmitter.STRUCTURED_HEADER, false);

if ("XLS".equalsIgnoreCase(ext)) {
options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter");
options.setOutputFileName(fileName + ".xls");
} else if ("XLSX".equalsIgnoreCase(ext)) {
options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsxEmitter");
options.setOutputFileName(fileName + ".xlsx");
}
return options;
</pre>
<br />
and I get the following error:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Jun 05, 2013 11:17:38 AM org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions
SEVERE: An error happened while running the report. Cause:
java.lang.IllegalArgumentException: Unknown margin constant: 4
at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.getMarginRec(PageSettingsBlock.java:413)
at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.setMargin(PageSettingsBlock.java:442)
at org.apache.poi.hssf.usermodel.HSSFSheet.setMargin(HSSFSheet.java:1031)
at uk.co.spudsoft.birt.emitters.excel.StyleManagerUtils.prepareMarginDimensions(StyleManagerUtils.java:956)
at uk.co.spudsoft.birt.emitters.excel.handlers.PageHandler.createSheet(PageHandler.java:248)
at uk.co.spudsoft.birt.emitters.excel.handlers.PageHandler.startTable(PageHandler.java:450)
at uk.co.spudsoft.birt.emitters.excel.ExcelEmitter.startTable(ExcelEmitter.java:331)
at org.eclipse.birt.report.engine.emitter.CompositeContentEmitter.startTable(CompositeContentEmitter.java:306)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEmitter.startTable(HTMLTableLayoutEmitter.java:386)
at org.eclipse.birt.report.engine.emitter.ContentEmitterUtil.startContent(ContentEmitterUtil.java:50)
at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:83)
at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)
at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)
at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)
at org.eclipse.birt.report.engine.layout.html.buffer.HTMLPageBuffer.startContent(HTMLPageBuffer.java:113)
at org.eclipse.birt.report.engine.layout.html.buffer.TableBreakBuffer.startContent(TableBreakBuffer.java:287)
at org.eclipse.birt.report.engine.layout.html.HTMLLeafItemLM.start(HTMLLeafItemLM.java:67)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:139)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at com.****.report.birt.BirtReportGenerator.generateReport(BirtReportGenerator.java:104)
at com.****.report.birt.SyncWorker.processMessage(SyncWorker.java:94)
at com.****.report.birt.SyncWorker.run(SyncWorker.java:89)
</pre>
<br />
So my code can find the jars but I have not found any settings for margins except at the hssf level and not sure why I need to based on how BIRT generates other outputs such as HTML or PDF.<br />
<br />
I also looked over:<br />
<br />
<a class='bbc_url' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/src/e67f9d2539ed/SpudSoft BIRT Excel Emitters Tests/src/uk/co/spudsoft/birt/emitters/excel/tests'>SpudSoft Examples</a><br />
<br />
and it appears I am using the emitter correctly? I have tried using the EXCELRenderOption with no change in the end result or trying with just setting EmitterID and no other options.<br />
<br />
Any help appreciated - thank you.

Find more posts tagged with

Comments

Yaytay

<blockquote class='ipsBlockquote' data-author="'pgtips'" data-cid="117369" data-time="1370451274" data-date="05 June 2013 - 09:54 AM"><p>
<pre class='_prettyXprint _lang-auto _linenums:0'>
Jun 05, 2013 11:17:38 AM org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions
SEVERE: An error happened while running the report. Cause:
java.lang.IllegalArgumentException: Unknown margin constant: 4
at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.getMarginRec(PageSettingsBlock.java:413)
at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.setMargin(PageSettingsBlock.java:442)
at org.apache.poi.hssf.usermodel.HSSFSheet.setMargin(HSSFSheet.java:1031)
at uk.co.spudsoft.birt.emitters.excel.StyleManagerUtils.prepareMarginDimensions(StyleManagerUtils.java:956)
</pre></p></blockquote>
The error is coming from this line:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
sheet.setMargin(Sheet.HeaderMargin, topMargin);
</pre>
And it appears that POI doesn't understand the Sheet.HeaderMargin constant.<br />
<br />
My suspicion is that you are using a different version of POI from the emitter.<br />
BIRT 4.2 itself comes with a version of POI (which is incomplete and out of date), so if the JVM is picking up that version in preference to the full v3.9 it might lead to that error.<br />
<br />
Check your final war file for any jar or class files that relate to POI, and make sure you've only got v3.9.<br />
<br />
The BIRT build that comes via Maven actually include the POI classes expanded out within the BIRT jar (which is a terrible practice and <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=398774'>should be fixed soon</a>) so it's really awkward to get rid of them.<br />
I have had success using the pom from vlad attached to <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=398774'>BIRT bug 398774</a>, but it's rather nasty to have to do as it involves creating a separate maven project just to prepare BIRT.<br />
I can provide more details if you want.<br />
<br />
Jim

pgtips

Hi Jim - thanks for the reply.

Per your insight I looked over the .war file in File Roller (linux) and under WEB-INF/lib/org.eclipse.birt.runtime_4.2.2v20130216-1152.jar/org/apache I removed the poi directory. File Roller then prompts to save the changes to the .war file which I did.

Uploaded and Tomcat7 took care of the .war file. Ran a report and came out creamy buttery mashed potato! ['Spud'Soft

] Yeehaaa!

Thank you.

rveeraraghav

<p>Hi Jim,</p><p> I used your excel emitter and for most part it has worked. Thank you very much for that. However, I do have a couple of issues which I have not been able to solve. These are</p><p>1. I have 3 datasets where each data set is a birt table. I would like to see 3 excel sheets and</p><p>2. Not have column headers in excel</p><p> </p><p>I tried and changed BirtExportReportDialog.js with the following line</p><div>if(format == "xls") {</div><div>action = action + " &__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsEmitter&ExcelEmitter.DisplayRowColHeadings=false&ExcelEmitter.SingleSheet=false";</div><div>}</div><div> </div><div>but the resultant excel still has only 1 sheet and the column headers are still present. What can I do to achieve correct results.</div><div> </div><div>Thanks,</div><div> Ravi</div>