报表报错：net.sf.jasperreports.engine.JRException: Can't add cell.

2010-06-02 02:15:30 719 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

IDEA导出pdf错误:net.sf.jasperreports.engine.JRException: Error trying to export to file 问题报错如下： net.sf.jasperreports.engine.JRException: Error trying to export to file : D:\ireport\dn_201409261257140622378.pdf at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExp... 阅读详情

ireport做成报表模板通过Datasource填充数据。转换成pdf,html,word都是可以的。但是转换成Excel的时候竟然报错：net.sf.jasperreports.engine.JRException: Can't add cell.
at net.sf.jasperreports.engine.export.JExcelApiExporter.exportText(JExcelApiExporter.java:368)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:442)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:361)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:178)
at com.qwserv.itm.pfl.rpt.engine.DefaultReportGenerator.xls(DefaultReportGenerator.java:303)
at com.qwserv.itm.pfl.rpt.servlet.ReportEngineServlet.doGet(ReportEngineServlet.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
这个问题我看了代码感觉没问题。。求救啊！
谢谢啊，能帮我解决这个问题我一定给高分。。。。。

...全文

Spring Boot项目里，如何优雅地集成JasperReports生成动态PDF报表？（附完整配置流程）本文详细介绍了在Spring Boot项目中如何优雅集成JasperReports生成动态PDF报表的完整实践。从依赖管理、字体配置到服务层设计，提供了模块化、可复用的解决方案，并分享了性能优化技巧和高级应用场景，帮助开发者高效实现企业级报表功能。阅读详情

dxjaccp

Java EE 67,535 成员 225,843 内容

+ 关注 + 加入社区

切换为时间正序

kaynezhang 2010-06-02

打赏
举报

[Quote=引用 2 楼 izard999 的回复:]

jre. 虽然我没有过这个东西, 但是用jaboc操作word excel,是要往你的jdk的jre下面放一个叫jaboc.dll的文件, 要不然就搞不了
[/Quote]
jasperreport使用的是jxl操作excel的，不存在你说的问题。

以下是jasperreport源码中相关于你的代码出错的部分。
public void exportText(JRPrintText text, JRExporterGridCell gridCell, int col, int row) throws net.sf.jasperreports.engine.JRException
{
addMergeRegion(gridCell, col, row);

JRStyledText styledText = getStyledText(text);

if (styledText != null)
{
Colour forecolor = getWorkbookColour(text.getForecolor());
WritableFont cellFont = getLoadedFont(text, forecolor.getValue(), getTextLocale(text));

JRXlsAbstractExporter.TextAlignHolder alignment = getTextAlignHolder(text);
int horizontalAlignment = getHorizontalAlignment(alignment);
int verticalAlignment = getVerticalAlignment(alignment);
int rotation = getRotation(alignment);

Pattern mode = this.backgroundMode;
Colour backcolor = WHITE;

if (gridCell.getCellBackcolor() != null)
{
mode = Pattern.SOLID;
backcolor = getWorkbookColour(gridCell.getCellBackcolor());
}

StyleInfo baseStyle = new StyleInfo(this, mode, backcolor, horizontalAlignment, verticalAlignment, rotation, cellFont, gridCell);

String textStr = styledText.getText();

String href = null;
JRHyperlinkProducer customHandler = getCustomHandler(text);
if (customHandler == null);
switch (text.getHyperlinkType())
{
case 2:
href = text.getHyperlinkReference();
break;
case 1:
case 3:
case 4:
case 5:
case 6:
default:
break label224:

href = customHandler.getHyperlink(text);
}

try
{
if (href != null)
{
try
{
label224: URL url = new URL(href);
WritableHyperlink hyperlink = new WritableHyperlink(col, row, col, row, url);
this.sheet.addHyperlink(hyperlink);
}
catch (MalformedURLException e)
{
log.warn("Reference \"" + href + "\" could not be parsed as URL: " + e);
}
}
addCell(col, row, text, textStr, baseStyle);
}
catch (Exception e)
{
throw new net.sf.jasperreports.engine.JRException("Can't add cell.", e);
}
}
}

好好检查你的单元格包含URL等一类的东西

izard999 2010-06-02

打赏
举报

jre. 虽然我没有过这个东西, 但是用jaboc操作word excel,是要往你的jdk的jre下面放一个叫jaboc.dll的文件, 要不然就搞不了

liqi4960710 2010-06-02

打赏
举报

路过…………帮顶！！！

报表报错：net.sf.jasperreports.engine.JRException: Can't add cell.

相关推荐