将图像插入Excel单元格时出现异常

Question

我是Java新手，需要在Microsoft Excel单元格中添加注释图像我的代码返回异常，有人可以帮助吗？我的Java代码

          public static void main(String[] args) throws Exception{
            /* Create a Workbook and Worksheet */
            HSSFWorkbook my_workbook = new HSSFWorkbook();
            HSSFSheet my_sheet = my_workbook.createSheet("MyBanner");               
            /* Read the input image into InputStream */
            InputStream image = new FileInputStream("C:/Users/Administrator/Desktop/New folder/Excel/Jellyfish.jpg");
            /* Convert Image to byte array */
            byte[] bytes = IOUtils.toByteArray(image);
            /* Add Picture to workbook and get a index for the picture */
            int my_picture_id = my_workbook.addPicture(bytes, Workbook.PICTURE_TYPE_JPEG);
            /* Close Input Stream */
            image.close();                
            /* Create the drawing container */
            HSSFPatriarch drawing = my_sheet.createDrawingPatriarch();
            /* Create an anchor point */
            ClientAnchor my_anchor = new HSSFClientAnchor();
            /* Define top left corner, and we can resize picture suitable from there */
            my_anchor.setCol1(2);
            my_anchor.setRow1(1);           
            /* Invoke createPicture and pass the anchor point and ID */
            HSSFPicture  my_picture = drawing.createPicture(my_anchor, my_picture_id);
            /* Call resize method, which resizes the image */
            my_picture.resize();            
            /* Write changes to the workbook */
            FileOutputStream out = new FileOutputStream(new File("C:/Users/Administrator/Desktop/New folder/Excel/Book1.xlsx"));
            my_workbook.write(out);
            out.close();
    }

这是一个例外

线程“main”java中出现异常。lang.NoClassDefFoundError:org/apache/commons/codec/digest/DigestUtils位于org。阿帕奇。波伊。hssf。用户模型。HSSF工作手册。在应用程序中添加图片（HSSFWorkbook.java:1575）。应用程序。main（App.java:39）由：java引起。lang.ClassNotFoundException:org。阿帕奇。平民编解码器。消化java的DigestUtils。网URLClassLoader。java上的findClass（URLClassLoader.java:381）。lang.ClassLoader。sun上的loadClass（ClassLoader.java:424）。杂项。启动器$AppClassLoader。java上的loadClass（Launcher.java:331）。lang.ClassLoader。loadClass（ClassLoader.java:357）。。。还有2个C:\Users\Administrator\AppData\Local\NetBeans\Cache\8.1\executor snippets\debug。xml:83:Java返回：1生成失败（总时间：0秒）

如何修复它？

Answer 1

你也可以用这种方式试试

final FileInputStream stream =
    new FileInputStream( "C:/Users/Administrator/Desktop/New folder/Excel/Jellyfish.jpg" );
final CreationHelper helper = workbook.getCreationHelper();
final Drawing drawing = sheet.createDrawingPatriarch();

final ClientAnchor anchor = helper.createClientAnchor();
anchor.setAnchorType( ClientAnchor.MOVE_AND_RESIZE );


     final int pictureIndex =
    workbook.addPicture( stream, Workbook.PICTURE_TYPE_JPEG );


  anchor.setCol1( 0 );
  anchor.setRow1( LOGO_ROW ); // same row is okay
  anchor.setRow2( LOGO_ROW );
  anchor.setCol2( 1 );
  final Picture pict = drawing.createPicture( anchor, pictureIndex );
  pict.resize();