blocks|key|3015634|text|多亏了belisarius+link，我们似乎找到了答案。它的基本方法是像往常一样为每个工作表创建JasperPrint对象。因此，您需要：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3015635|JasperPrint+firstWorkSheet+=+...;
JasperPrint+secondWorkSheet+=+...;|code-block|syntax|javascript|3015636|此时，JasperPrint对象已经填充了数据源。然后你就可以做到：|3015637|List<JRPrintPage>+pages+=+new+ArrayList<JRPrintPage>(secondWorkSheet.getPages());
int+i+=+firstWorkSheet.getPages().size();
for+(int+count+=+0;+count+<+pages.size();+count%2B%2B)+{
++++firstWorkSheet.addPage(i,+(JRPrintPage)+pages.get(count));
++++i%2B%2B;
}|3015638|这样做的目的是将i设置为firstWorkSheet中当前的页数(应该是1)。然后循环遍历secondWorkSheet中的页面并将它们添加到firstWorkSheet中。|offset|length|style|CODE|3015639|确保在jasperReport中将其设置为为每个工作表jrxml文件打印一页，这样就可以了。如果有什么变化，我会来更新的，但这应该可以工作。|3015640|更新：|BOLD|3015641|发现您需要使用net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter|3015642|而不是|3015643|net.sf.jasperreports.engine.export.JRXlsExporter|3015644|因为在导出到多个工作表时似乎存在问题。|3015645|此外，isIgnorePagination的jrxml文件中的设置还需要：|3015646|isIgnorePagination="true"|3015647|以便将每个jrxml文件导出为单个页面。|3015648|然后，您需要将JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET参数设置为true，以便将每页分解到单独的工作表中。|3015649|entityMap^0|0|0|0|0|8|1|C|E|19|F|0|0|0|3|0|7|1J|0|0|0|1C|0|0|3|I|0|0|P|0|0|7|18|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1E|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1F|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1G|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1H|8|@$M|1I|N|1J|O|P]|$M|1K|N|1L|O|P]|$M|1M|N|1N|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1O|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1P|8|@$M|1Q|N|1R|O|U]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1S|8|@$M|1T|N|1U|O|P]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1V|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1W|8|@$M|1X|N|1Y|O|P]]|9|@]|A|$]]|$1|11|3|12|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|20|8|@$M|21|N|22|O|P]]|9|@]|A|$]]|$1|15|3|16|5|6|7|23|8|@$M|24|N|25|O|P]]|9|@]|A|$]]|$1|17|3|18|5|6|7|26|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|27|8|@$M|28|N|29|O|P]]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|2A|8|@]|9|@]|A|$]]]|1C|$]]

Thanks to belisarius link we seem to have figured it out. The basics of how to do it is create your JasperPrint objects for each sheet as you normally would. So you have:

<pre><code>JasperPrint firstWorkSheet = ...;
JasperPrint secondWorkSheet = ...;
</code></pre>

The JasperPrint objects are already filled with the datasource at this point. Then you do:

<pre><code>List&lt;JRPrintPage&gt; pages = new ArrayList&lt;JRPrintPage&gt;(secondWorkSheet.getPages());
int i = firstWorkSheet.getPages().size();
for (int count = 0; count &lt; pages.size(); count++) {
 firstWorkSheet.addPage(i, (JRPrintPage) pages.get(count));
 i++;
}
</code></pre>

What this does it sets <code>i</code> to the number of pages currently in the <code>firstWorkSheet</code> (which should be one). Then it loops thourgh the pages in the <code>secondWorkSheet</code> and adds them to the firstWorkSheet.

Make sure in you jasperReport you have it set to print as one page for each of the work sheet jrxml files and you should be good to go. I will come update this if anything changes, but this should work.

UPDATE: 

Discovered you need to use 
<code>net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter</code> 

instead of 

<code>net.sf.jasperreports.engine.export.JRXlsExporter</code> 

as there seems to be an issue when exporting to multiple work sheets. 

Also the setting in the jrxml file for <code>isIgnorePagination</code> needs to be:

<code>isIgnorePagination="true"</code>

so that each jrxml file is exported as a single page.

Then you need to set <code>JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET</code> parameter to true so it breaks out each page to a separate worksheet.

blocks|key|3229873|text|多亏了这个线程，我可以更轻松地创建一个包含多张工作表的Excel导出。我发现您可以使用以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3229874|ArrayList<JasperPrint>+list+=+new++ArrayList<JasperPrint>();
list.add(jp1);+list.add(jp2);
exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT_LIST,+list);|code-block|syntax|javascript|3229875|导出器将自动使用每个JasperPrint对象来构造每个工作表；还将使用Jasper报告的名称(在jrxml文件中指定)作为每个工作表的名称。|3229876|目前这个解决方案在我的本地项目上有效，所以我只想让你知道。|3229877|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Thanks to this thread it really was easier for me to create an Excel export with multiple sheets. What I found out was that you could use the following:

<pre><code>ArrayList&lt;JasperPrint&gt; list = new ArrayList&lt;JasperPrint&gt;();
list.add(jp1); list.add(jp2);
exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT_LIST, list);
</code></pre>

and the exporter will automatically use every JasperPrint object to construct each sheet; also the name of the Jasper report (as specified in the jrxml file) is used as the name of each sheet.

Currently this solution works on my local project, so I just wanted to let you know.

blocks|key|291251|text|根据当前版本6.1.1，JRXlsExporter.setParameter已弃用。它应该被JRXlsExporter.setExporterInput所取代。因此，更新后的代码将是：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|291252|ArrayList<JasperPrint>+sheets+=+new+ArrayList<JasperPrint>();
sheets.add(sheet1);+
sheets.add(sheet2);

exporter.setExporterInput(SimpleExporterInput.getInstance(sheets));|code-block|syntax|javascript|291253|entityMap^0|C|Q|1A|U|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

As per current version 6.1.1, <code>JRXlsExporter.setParameter</code> is deprecated. It should be replaced by <code>JRXlsExporter.setExporterInput</code>. So, the updated code would be:

<pre><code>ArrayList&lt;JasperPrint&gt; sheets = new ArrayList&lt;JasperPrint&gt;();
sheets.add(sheet1); 
sheets.add(sheet2);

exporter.setExporterInput(SimpleExporterInput.getInstance(sheets));
</code></pre>

We have a report that the customer would like to have exported to an excel format where it has multiple worksheets. Essentially the two queries share the same parameters, but everything else is different. 

In jasper-reports how do you export to an excel file with multiple worksheets (ideally from different data sources)?

How do you export a JasperReport to an Excel file with multiple worksheets?

我们有一份报告，客户希望将其导出为具有多个工作表的excel格式。本质上，这两个查询共享相同的参数，但其他一切都是不同的。jasper中的-报告如何导出到包含多个工作表的excel文件(理想情况下来自不同的数据源)？

问如何将JasperReport导出到包含多个工作表的Excel文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将JasperReport导出到包含多个工作表的Excel文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将JasperReport导出到包含多个工作表的Excel文件？
EN