<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>

<dependency>
    <groupId>e-iceblue</groupId>
    <artifactId>spire.xls</artifactId>
    <version>15.6.3</version>
</dependency>

import com.spire.xls.*;

import java.awt.*;
import java.util.EnumSet;
import java.util.HashMap;

public class ReplacePlaceholderText {
    public static void main(String[] args) {
        // 打開Excel模板
        Workbook workbook = new Workbook();
        workbook.loadFromFile("占位符模板.xlsx");

        // 獲取指定工作表（工作表索引從0開始）
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 定義要替換的占位符及對應(yīng)值
        HashMap<String, Object> replacements = new HashMap<>();
        replacements.put("{姓名}", "張立強");
        replacements.put("{年齡}", 28);
        replacements.put("{職位}", "財務(wù)總監(jiān)");

        // 在工作表中查找占位符并替換為對應(yīng)值
        for (String placeholder : replacements.keySet()) {
            Object value = replacements.get(placeholder);
            CellRange[] foundRanges = sheet.findAll(placeholder, EnumSet.of(FindType.Text), EnumSet.of(ExcelFindOptions.MatchEntireCellContent));
            for (int i = 0; i < foundRanges.length; i++) {
                CellRange cell = foundRanges[i];
                cell.setValue2(value);
                // 高亮替換后的單元格 （可選）
                cell.getStyle().setColor(Color.YELLOW);
            }
        }

        // 保存結(jié)果文件
        workbook.saveToFile("替換占位符.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}

import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
import com.spire.xls.data.table.DataColumn;
import com.spire.xls.data.table.DataRow;
import com.spire.xls.data.table.DataTable;

public class ApplySmartMarker {
    public static void main(String[] args) throws Exception {
        // 加載 Excel 模板
        Workbook workbook = new Workbook();
        workbook.loadFromFile("智能標記模板.xlsx");

        // 獲取第一個工作表
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 創(chuàng)建一個新的 DataTable 對象，并命名為 "data"
        DataTable dt = new DataTable();
        dt.setTableName("data");

        // 添加三列：姓名、年齡、職位
        dt.getColumns().add(new DataColumn("姓名"));
        dt.getColumns().add(new DataColumn("年齡"));
        dt.getColumns().add(new DataColumn("職位"));

        // 創(chuàng)建數(shù)據(jù)行
        DataRow row1 = dt.newRow();
        row1.setString("姓名", "張三");
        row1.setString("年齡", "28");
        row1.setString("職位", "銷售經(jīng)理");

        DataRow row2 = dt.newRow();
        row2.setString("姓名", "李四");
        row2.setString("年齡", "32");
        row2.setString("職位", "市場主管");

        DataRow row3 = dt.newRow();
        row3.setString("姓名", "王五");
        row3.setString("年齡", "25");
        row3.setString("職位", "技術(shù)支持");

        // 添加數(shù)據(jù)行到表格中
        dt.getRows().add(row1);
        dt.getRows().add(row2);
        dt.getRows().add(row3);

        // 綁定表格的數(shù)據(jù)
        workbook.getMarkerDesigner().addDataTable("data", dt);

        // 應(yīng)用Smart Marker，填充數(shù)據(jù)
        workbook.getMarkerDesigner().apply();

        // 自動調(diào)整行高和列寬 （可選）
        //sheet.getAllocatedRange().autoFitRows();
        //sheet.getAllocatedRange().autoFitColumns();

        // 保存結(jié)果文件
        workbook.saveToFile("應(yīng)用智能標記.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}

import com.spire.xls.*;
import java.util.ArrayList;

public class BindCustomObjects {
    // 定義一個Student類
    public static class Student {
        private String Name;
        private String Course;
        private int Score;
        // 定義構(gòu)造函數(shù)，參數(shù)包括：學(xué)生姓名、課程、分數(shù)
        public Student(String name, String course, int score) {
            this.Name = name;
            this.Course = course;
            this.Score = score;
        }
    }
    public static void main(String[] args) {
        // 創(chuàng)建Excel模板文檔
        Workbook workbook = new Workbook();

        // 獲取第一個工作表
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 添加表頭
        sheet.getCellRange("A1").setValue("姓名");
        sheet.getCellRange("B1").setValue("課程");
        sheet.getCellRange("C1").setValue("分數(shù)");

        // 添加Smart Marker智能標記
        sheet.getCellRange("A2").setValue("&=Student.Name(add:styles)");
        sheet.getCellRange("B2").setValue("&=Student.Course(add:styles)");
        sheet.getCellRange("C2").setValue("&=Student.Score(add:styles)");

        // 設(shè)置單元格格式
        sheet.getCellRange("A1:C2").getCellStyle().setHorizontalAlignment(HorizontalAlignType.Center);
        sheet.getCellRange("A1:C1").getCellStyle().getFont().isBold(true);
        sheet.getCellRange("A1:C1").getCellStyle().getFont().setSize(12);
        sheet.getCellRange("A2:C2").getCellStyle().getFont().setSize(11);

        // 創(chuàng)建一個ArrayList來存儲Student對象
        ArrayList<Student> list = new ArrayList<>();

        // 添加3個學(xué)生對象
        list.add(new Student("喬治", "語文", 62));
        list.add(new Student("佩琪", "數(shù)學(xué)", 88));
        list.add(new Student("艾米麗", "英語", 95));

        // 綁定ArrayList數(shù)據(jù)到Smart Marker
        workbook.getMarkerDesigner().addParameter("Student", list);

        // 應(yīng)用Smart Marker，填充數(shù)據(jù)
        workbook.getMarkerDesigner().apply();

        // 保存結(jié)果文件
        workbook.saveToFile("添加自定義數(shù)據(jù)類型.xlsx", ExcelVersion.Version2013);
        workbook.dispose();
    }
}

workbook.saveToFile("添加自定義數(shù)據(jù)類型.pdf", FileFormat.PDF);