<repositories>
    <repository>
        <id>e-iceblue</id>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>13.10.1</version> <!-- 請?zhí)鎿Q為最新版本 -->
    </dependency>
</dependencies>

repositories {
    maven { url 'https://repo.e-iceblue.cn/repository/maven-public/' }
}
dependencies {
    implementation 'e-iceblue:spire.xls:13.10.1' // 請?zhí)鎿Q為最新版本
}

import com.spire.xls.*;

public class ExcelDeleter {

    public static void main(String[] args) throws Exception {
        // 創(chuàng)建一個Workbook實(shí)例并加載Excel文件
        Workbook workbook = new Workbook();
        workbook.loadFromFile("input.xlsx"); // 替換為你的Excel文件路徑

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

        // ... 在這里執(zhí)行刪除操作 ...

        // 保存修改后的Excel文件
        workbook.saveToFile("output.xlsx", ExcelVersion.Version2016);
        workbook.dispose(); // 釋放資源
    }
}

import com.spire.xls.*;

public class DeleteSingleRow {
    public static void main(String[] args) throws Exception {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("input.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 刪除第5行（索引為5）
        // 刪除后，原第6行將變?yōu)榈?行，以此類推。
        sheet.deleteRow(5); 
        System.out.println("成功刪除第5行。");

        workbook.saveToFile("output_single_row_deleted.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}

import com.spire.xls.*;

public class DeleteMultipleRows {
    public static void main(String[] args) throws Exception {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("input.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 從第3行開始，刪除4行（即刪除第3、4、5、6行）
        sheet.deleteRow(3, 4); 
        System.out.println("成功刪除從第3行開始的4行。");

        workbook.saveToFile("output_multiple_rows_deleted.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}

import com.spire.xls.*;
import com.spire.xls.collections.CellRange;

public class DeleteRowByKeyword {
    public static void main(String[] args) throws Exception {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("input.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 查找包含 "Address" 字符串的單元格
        // 第一個參數(shù)是查找的字符串，第二個參數(shù)表示是否區(qū)分大小寫，第三個參數(shù)表示是否匹配整個單元格內(nèi)容
        CellRange cr = sheet.findString("Address", false, false);

        if (cr != null) {
            // 刪除包含該字符串的行
            sheet.deleteRow(cr.getRow());
            System.out.println("成功刪除包含 'Address' 關(guān)鍵字的行。");
        } else {
            System.out.println("未找到包含 'Address' 關(guān)鍵字的行。");
        }
        
        workbook.saveToFile("output_row_by_keyword_deleted.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}

import com.spire.xls.*;

public class DeleteSingleColumn {
    public static void main(String[] args) throws Exception {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("input.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 刪除第C列（索引為3）
        // 刪除后，原第D列將變?yōu)榈贑列，以此類推。
        sheet.deleteColumn(3); 
        System.out.println("成功刪除第C列。");

        workbook.saveToFile("output_single_column_deleted.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}

import com.spire.xls.*;

public class DeleteMultipleColumns {
    public static void main(String[] args) throws Exception {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("input.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 從第B列（索引為2）開始，刪除2列（即刪除第B、C列）
        sheet.deleteColumn(2, 2); 
        System.out.println("成功刪除從第B列開始的2列。");

        workbook.saveToFile("output_multiple_columns_deleted.xlsx", ExcelVersion.Version2016);
        workbook.dispose();
    }
}