<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>15.10.5</version>
    </dependency>
</dependencies>

import com.spire.xls.*;
 
public class InsertComments {
    public static void main(String[] args){
        //新建Excel文檔
        Workbook workbook = new Workbook();
        //獲取第一張工作表
        Worksheet sheet = workbook.getWorksheets().get(0);
 
        //創(chuàng)建字體
        ExcelFont font = workbook.createFont();
        font.setFontName("Arial");
        font.setSize(11);
        font.setKnownColor(ExcelColors.Orange);
        ExcelFont fontBlue = workbook.createFont();
        fontBlue.setKnownColor(ExcelColors.LightBlue);
        ExcelFont fontGreen = workbook.createFont();
        fontGreen.setKnownColor(ExcelColors.LightGreen);
 
        //給指定的Excel單元格添加普通批注
        CellRange range = sheet.getCellRange("A1");
        range.setText("Spire.XLS");
        range.getComment().setText("Excel文檔處理組件");
        range.autoFitColumns();
 
        //給指定的Excel單元格添加富文本批注
        range = sheet.getCellRange("A2");
        range.setText("Spire.XLS");
        range.getRichText().setFont(0, 8, font);
        range.autoFitColumns();
        range.getComment().getRichText().setText("Excel文檔處理組件");
        range.getComment().getRichText().setFont(0, 4, fontGreen);
        range.getComment().getRichText().setFont(5, 6, fontBlue);
 
        //保存結(jié)果文檔
        workbook.saveToFile("AddComments.xlsx", ExcelVersion.Version2013);
    }
}

import com.spire.xls.*;
 
public class deleteComment {
    public static void main(String[] args) {
 
        //創(chuàng)建Workbook類的對象
        Workbook wb = new Workbook();
 
        //載入Excel文件
        wb.loadFromFile("新員工信息.xlsx");
 
        //獲取載入的工作簿的第一個(gè)工作表
        Worksheet sheet = wb.getWorksheets().get(0);
 
        //獲取指定單元格的批注并刪除
        sheet.getRange().get("A4").getComment().remove();
 
        //保存文件
        wb.saveToFile("刪除批注.xlsx", ExcelVersion.Version2013);
        wb.dispose();
    }
}