<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.12.1</version> <!-- 請(qǐng)?zhí)鎿Q為最新版本 -->
    </dependency>
</dependencies>

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

import com.spire.xls.*;

public class ExcelReader {
    public static void main(String[] args) {
        // 加載Excel文件
        Workbook workbook = new Workbook();
        try {
            workbook.loadFromFile("path/to/your/excel/data.xlsx");
            System.out.println("Excel文件加載成功！");
            // 后續(xù)操作...
        } catch (Exception e) {
            e.printStackTrace();
            System.err.println("加載Excel文件失敗：" + e.getMessage());
        }
    }
}

import com.spire.xls.*;

public class AccessCells {
    public static void main(String[] args) {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("path/to/your/excel/data.xlsx");

        // 獲取第一個(gè)工作表（索引從0開始）
        Worksheet sheet = workbook.getWorksheets().get(0);
        // 或者通過名稱獲取工作表
        // Worksheet sheet = workbook.getWorksheets().get("Sheet1");

        // 訪問A1單元格（行索引1，列索引1）
        CellRange cellA1 = sheet.getCellRange("A1");
        System.out.println("A1單元格的值: " + cellA1.getText());

        // 訪問B2單元格（行索引2，列索引2）
        CellRange cellB2 = sheet.getCellRange(2, 2); // 行索引，列索引
        System.out.println("B2單元格的值: " + cellB2.getText());
    }
}

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

public class DataTypeReader {
    public static void main(String[] args) {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("path/to/your/excel/data.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 假設(shè)A1是字符串，B1是數(shù)字，C1是日期，D1是布爾值，E1是公式
        CellRange cellA1 = sheet.getCellRange("A1");
        System.out.println("A1 (String): " + cellA1.getText());

        CellRange cellB1 = sheet.getCellRange("B1");
        // 建議先判斷單元格類型
        if (cellB1.getCellType() == CellType.Number) {
            System.out.println("B1 (Number): " + cellB1.getNumberValue());
        }

        CellRange cellC1 = sheet.getCellRange("C1");
        if (cellC1.getCellType() == CellType.DateTime) {
            Date dateValue = cellC1.getDateTimeValue();
            System.out.println("C1 (Date): " + dateValue);
        }

        CellRange cellD1 = sheet.getCellRange("D1");
        if (cellD1.getCellType() == CellType.Boolean) {
            System.out.println("D1 (Boolean): " + cellD1.getBooleanValue());
        }

        CellRange cellE1 = sheet.getCellRange("E1");
        if (cellE1.getCellType() == CellType.Formula) {
            System.out.println("E1 (Formula): " + cellE1.getFormula());
            System.out.println("E1 (Formula Result): " + cellE1.getFormulaNumberValue());
        }

        // 錯(cuò)誤處理：對(duì)于不確定類型的單元格，最好使用try-catch或先判斷CellType
        try {
            String invalidNumber = sheet.getCellRange("F1").getText(); // 假設(shè)F1是文本"abc"
            double num = Double.parseDouble(invalidNumber);
            System.out.println("F1 Number: " + num);
        } catch (NumberFormatException e) {
            System.err.println("F1不是有效的數(shù)字格式。原始文本: " + sheet.getCellRange("F1").getText());
        }
    }
}

import com.spire.xls.*;

public class IterateSheetData {
    public static void main(String[] args) {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("path/to/your/excel/data.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);

        // 獲取工作表的已使用行數(shù)和列數(shù)
        int lastRow = sheet.getLastRow();
        int lastColumn = sheet.getLastColumn();

        System.out.println("工作表數(shù)據(jù)：");
        for (int r = 1; r <= lastRow; r++) { // 行索引從1開始
            for (int c = 1; c <= lastColumn; c++) { // 列索引從1開始
                CellRange cell = sheet.getCellRange(r, c);
                // 確保獲取的文本不為空，避免打印null
                System.out.print(cell.getText() + "\t");
            }
            System.out.println(); // 換行
        }
    }
}

import com.spire.xls.*;
import com.spire.xls.core.spreadsheet.collections.XlsMergedCellsCollection;

public class MergedCellHandler {
    public static void main(String[] args) {
        Workbook workbook = new Workbook();
        workbook.loadFromFile("path/to/your/excel/merged_data.xlsx"); // 假設(shè)此文件包含合并單元格
        Worksheet sheet = workbook.getWorksheets().get(0);

        int lastRow = sheet.getLastRow();
        int lastColumn = sheet.getLastColumn();

        for (int r = 1; r <= lastRow; r++) {
            for (int c = 1; c <= lastColumn; c++) {
                CellRange currentCell = sheet.getCellRange(r, c);

                // 檢查當(dāng)前單元格是否是合并區(qū)域的一部分
                if (currentCell.isMerged()) {
                    // 獲取合并區(qū)域的第一個(gè)單元格（左上角）
                    CellRange mergedCell = currentCell.getMergeRange();
                    if (mergedCell != null) {
                        System.out.print("合并單元格(" + r + "," + c + ")的值: " + mergedCell.getText() + "\t");
                    } else {
                        System.out.print("空合并單元格" + "\t");
                    }
                } else {
                    // 非合并單元格，直接獲取值
                    System.out.print("普通單元格(" + r + "," + c + ")的值: " + currentCell.getText() + "\t");
                }
            }
            System.out.println();
        }
        
        // 處理空單元格和異常數(shù)據(jù)：
        // 1. 對(duì)于空單元格，getText()通常返回空字符串或null。在處理前進(jìn)行null或空字符串檢查。
        // 2. 對(duì)于異常數(shù)據(jù)（如預(yù)期數(shù)字但實(shí)際是文本），使用try-catch塊捕獲轉(zhuǎn)換異常，或在轉(zhuǎn)換前檢查CellType。
    }
}