<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.11.3</version>
    </dependency>
</dependencies>

import com.spire.xls.*;

public class ReadProperties {
    public static void main(String[] args) {
        //加載Excel文檔
        Workbook wb = new Workbook();
        wb.loadFromFile("AddProperties.xlsx");

        //讀取Excel內(nèi)置文檔屬性
        System.out.println("標(biāo)題： " + wb.getDocumentProperties().getTitle());
        System.out.println("主題： " + wb.getDocumentProperties().getSubject());
        System.out.println("作者： " + wb.getDocumentProperties().getAuthor());
        System.out.println("單位： " + wb.getDocumentProperties().getCompany());
        System.out.println("主管： " + wb.getDocumentProperties().getManager());
        System.out.println("類別： " + wb.getDocumentProperties().getCategory());
        System.out.println("關(guān)鍵字： " + wb.getDocumentProperties().getKeywords());

        //獲取Excel自定義文檔屬性
        DocumentProperty property = (DocumentProperty) wb.getCustomDocumentProperties().get(0);
        //讀取第一個(gè)自定義文檔屬性的名稱和值
        System.out.println("名稱： " + property.getName());
        System.out.println("值： " + property.getValue());
    }
}

import com.spire.xls.*;

public class RemoveProperties {
    public static void main(String[] args) {
        //加載Excel文檔
        Workbook wb = new Workbook();
        wb.loadFromFile("AddProperties.xlsx");

        //通過將對(duì)應(yīng)文檔屬性的值設(shè)置為空來刪除該內(nèi)置屬性
        wb.getDocumentProperties().setTitle("");
        wb.getDocumentProperties().setSubject("");
        wb.getDocumentProperties().setAuthor("");
        wb.getDocumentProperties().setCompany("");
        wb.getDocumentProperties().setManager("");
        wb.getDocumentProperties().setCategory("");
        wb.getDocumentProperties().setKeywords("");
        wb.getDocumentProperties().setComments("");

        //根據(jù)自定義文檔屬性的名稱來移除該自定義文檔屬性
        wb.getCustomDocumentProperties().remove("編輯");
        wb.getCustomDocumentProperties().remove("聯(lián)系電話");

        //保存文檔
        wb.saveToFile("RemoveProperties.xlsx", ExcelVersion.Version2010);
        wb.dispose();
    }
}