个人中心
gpt4 book ai didi

java - 无法使用 jasper 报告在 xls 文档中显示图表

转载 作者：行者123 更新时间：2023-12-02 04:14:28 25 4
gpt4 key购买 nike

我是 jasper reports 的新手。我可以通过 Jasper 报告将数据导出到 Excel 工作表。当我在 iReports 中创建饼图时，它显示在预览中。当我在 jsp 文件中编写以下代码以在 JasperViewer 中查看报告时，它会显示数据和图表。但是当我尝试将该文档(即在 JasperViewer 中，它提供了多种以 PDF、RTF 或 XLS 格式保存报告的方法)保存为 XLS 时，控制台中出现错误 

net.sf.jasperreports.engine.JRException: The cell cannot be added.

但是，当我从 .jrxml 文件中删除图表时，我可以将数据导出到 Excel 文件。我还阅读了一些将 JR 图表作为图像插入 Excel 文档中的内容。但 xls 文档没有拍摄任何图像。下面是我的 JSP 文件:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.sql.*,java.util.*,
    net.sf.jasperreports.engine.*,java.io.*,
net.sf.jasperreports.engine.design.*,
net.sf.jasperreports.view.JasperViewer" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3309/jasperdb", "root", "root");
FileInputStream fis=new FileInputStream(new File("C://Documents and Settings//james//report1.jrxml"));
JasperReport jasperreport=JasperCompileManager.compileReport(fis);
JasperPrint jasperprint=JasperFillManager.fillReport(jasperreport,null,con); 
      JasperViewer jv=new JasperViewer(jasperprint,false);
      jv.setTitle("test");
      jv.setIconImage(null);
      jv.setVisible(true);
}catch(Exception ex){
    ex.printStackTrace();
}
%>
</body>
</html>

jsp加载时输出: enter image description here

当我单击“保存”按钮并选择 xls 作为要保存的报告时，控制台中会出现以下错误:

net.sf.jasperreports.engine.JRException: The cell cannot be added.
    at net.sf.jasperreports.engine.export.JRXlsExporter.exportImage(JRXlsExporter.java:1683)
    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:1047)
    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:831)
    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:678)
    at net.sf.jasperreports.view.save.JRSingleSheetXlsSaveContributor.save(JRSingleSheetXlsSaveContributor.java:123)
    at net.sf.jasperreports.swing.JRViewerToolbar.btnSaveActionPerformed(JRViewerToolbar.java:406)
    at net.sf.jasperreports.swing.JRViewerToolbar$1.actionPerformed(JRViewerToolbar.java:136)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/codec/digest/DigestUtils
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.addPicture(HSSFWorkbook.java:1610)
    at net.sf.jasperreports.engine.export.JRXlsExporter.exportImage(JRXlsExporter.java:1667)
    ... 43 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.codec.digest.DigestUtils
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1702)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1547)
    ... 45 more

这只是由于图表图像而发生的。指导我如何将图表导出为 xls 文档中的图像以及其余数据。

最佳答案

哦!我真是个傻子。最底部的控制台错误尖叫着并告诉 找不到类异常由: java.lang.ClassNotFoundException: org.apache.commons.codec.digest.DigestUtils
 为了解决这个问题，我下载了 commons-codec-1.4.jar 文件并将其放置在 web-inf lib 文件夹中。现在一切正常。

关于java - 无法使用 jasper 报告在 xls 文档中显示图表，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/33465234/

25 4 0
文章推荐： java - ImageJ 插件开发没有错误消息
文章推荐： java - 与所有者框架异步打开 JDialog 的问题
文章推荐： java - 将十进制转换为 IEEE 二进制
文章推荐： java - 未能成功演示并发递增/递减
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com