如何使用 apache poi 为 3 个单元格设置注释 [英] How to set comments for 3 cells using apache poi

问题描述

我想使用 Apache POI 为 3 个 excel 单元格设置注释.

I want to set comments for 3 excel cells using Apache POI.

这是我的源代码:

import java.io.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;

public class CellComments
{
    public static void main(String[] args) throws IOException  {

      HSSFWorkbook wb = new HSSFWorkbook();
      HSSFSheet sheet = wb.createSheet("Cell comments in POI HSSF");


      HSSFPatriarch patr = sheet.createDrawingPatriarch();
      HSSFCell cell1 = sheet.createRow(3).createCell((short)1);
      cell1.setCellValue(new HSSFRichTextString("Hello, World"));

      //anchor defines size and position of the comment in worksheet
      HSSFComment comment1 = patr.createComment(new HSSFClientAnchor(100, 100, 100, 100, (short)1, 1, (short) 6, 5));
      comment1.setString(new HSSFRichTextString("FirstComments"));
      cell1.setCellComment(comment1);
      System.out.println("Cell comments: "+cell1.getCellComment().getString());

      patr = sheet.createDrawingPatriarch();
      comment1 = patr.createComment(new HSSFClientAnchor(100, 100, 100, 100, (short)1, 1, (short) 6, 5));
      //HSSFComment comment2=patr.createComment(new HSSFClientAnchor(100, 100, 100, 100, (short)1, 1, (short) 6, 5));
      HSSFCell cell2 = sheet.createRow(6).createCell((short)1);
      cell2.setCellValue(36.6);
      comment1.setString(new HSSFRichTextString("second commetns"));
      cell2.setCellComment(comment1);
      System.out.println("Cell comments: "+cell2.getCellComment().getString());

      patr = sheet.createDrawingPatriarch();
      comment1 = patr.createComment(new HSSFClientAnchor(100, 100, 100, 100, (short)1, 1, (short) 6, 5));
      //HSSFComment comment3=patr.createComment(new HSSFClientAnchor(100, 100, 100, 100, (short)1, 1, (short) 6, 5));
      cell2 = sheet.createRow(10).createCell((short)1);
      cell2.setCellValue(150);
      comment1.setString(new HSSFRichTextString("Third commetns"));
      cell2.setCellComment(comment1);
      System.out.println("Cell comments: "+cell2.getCellComment().getString());

      FileOutputStream out = new FileOutputStream("C:/Documents and Settings/saravanan/Desktop/cellcomments.xls");
      wb.write(out);
      out.close();

    }
}

运行程序时，只为最后一个单元格设置注释.但是我打印了前两个单元格的注释，它打印得很好.但在excel表中没有显示?这里有什么不正确?

While run the program, comments set only for last cell. But I printed the comments for the first two cells it was printed fine. But not shown in the excel sheet? What's incorrect here?

推荐答案

有一次你问了一个问题，让我尝试了一段时间的代码.

For once you've asked a question which had me trying out the code for a while.

你的问题是这行出现了 3 次，每次评论前出现一次.

Your problem is this line appears 3 times, once before each comment.

patr = sheet.createDrawingPatriarch();

来自文档 对于这种方法，

创建顶层绘图族长.这样会有效果删除任何现有的图纸这张表.

Creates the top-level drawing patriarch. This will have the effect of removing any existing drawings on this sheet.

因此，每次创建 DrawingPatriarch 时，您之前的评论都会被删除.

So whats happening is that your earlier comments are getting removed each time you create the DrawingPatriarch.

所以只做一次，在comment1之前.其他 2 次，删除或注释掉这一行.

So do this only once, before comment1. The other 2 times, remove or comment out this line.

这篇关于如何使用 apache poi 为 3 个单元格设置注释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！