<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>15.12.15</version>
    </dependency>
</dependencies>

import com.spire.xls.CellRange;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class ReadData {

    public static void main(String[] args) {

        // 創(chuàng)建一個(gè) Workbook 對象
        Workbook wb = new Workbook();

        // 加載現(xiàn)有的 Excel 文件
        wb.loadFromFile("C:/Users/Administrator/Desktop/NewSpreadsheet.xlsx");

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

        // 獲取包含數(shù)據(jù)的單元格范圍
        CellRange locatedRange = sheet.getAllocatedRange();

        // 遍歷行
        for (int i = 0; i < locatedRange.getRows().length; i++) {

            // 遍歷列
            for (int j = 0; j < locatedRange.getColumnCount(); j++) {

                // 獲取特定單元格的數(shù)據(jù)
                System.out.print(locatedRange.get(i + 1, j + 1).getValue() + "  ");
            }
            System.out.println();
        }
    }
}

import com.spire.xls.*;

public class CreateSpreadsheet {

    public static void main(String[] args) {

        // 創(chuàng)建一個(gè) Workbook 對象
        Workbook wb = new Workbook();

        // 移除默認(rèn)工作表
        wb.getWorksheets().clear();

        // 添加一個(gè)名為 "員工" 的工作表
        Worksheet sheet = wb.getWorksheets().add("員工");

        // 合并 A1 到 G1 的單元格
        sheet.getRange().get("A1:G1").merge();

        // 向 A1 寫入數(shù)據(jù)并應(yīng)用格式
        sheet.getRange().get("A1").setValue("華宇汽車公司員工基本信息");
        sheet.getRange().get("A1").setHorizontalAlignment(HorizontalAlignType.Center);
        sheet.getRange().get("A1").setVerticalAlignment(VerticalAlignType.Center);
        sheet.getRange().get("A1").getStyle().getFont().isBold(true);
        sheet.getRange().get("A1").getStyle().getFont().setSize(13);

        // 設(shè)置第一行的高度
        sheet.setRowHeight(1, 30);

        // 創(chuàng)建一個(gè)二維數(shù)組
        String[][] twoDimensionalArray = new String[][]{
                {"姓名", "性別", "出生日期", "學(xué)歷", "聯(lián)系電話", "職位", "編號(hào)"},
                {"艾倫", "男", "1990-02-10", "本科", "24756854", "機(jī)械師", "0021"},
                {"帕特里克", "男", "1985-06-08", "碩士", "59863247", "機(jī)械師", "0022"},
                {"珍娜", "女", "1989-11-25", "本科", "79540352", "銷售", "0023"},
                {"湯米", "男", "1988-04-16", "碩士", "52014060", "機(jī)械師", "0024"},
                {"克里斯蒂娜", "女", "1998-01-21", "本科", "35401489", "人力資源", "0025"}
        };

        // 從數(shù)組導(dǎo)入數(shù)據(jù)到工作表
        sheet.insertArray(twoDimensionalArray, 2, 1);

        // 設(shè)置一個(gè)范圍的行高
        sheet.getRange().get("A2:G7").setRowHeight(15);

        // 設(shè)置列寬
        sheet.setColumnWidth(2, 15);
        sheet.setColumnWidth(3, 21);
        sheet.setColumnWidth(4, 15);

        // 設(shè)置邊框樣式
        sheet.getRange().get("A2:G7").borderAround(LineStyleType.Medium);
        sheet.getRange().get("A2:G7").borderInside(LineStyleType.Thin);
        sheet.getRange().get("A2:G2").borderAround(LineStyleType.Medium);
        sheet.getRange().get("A2:G7").getBorders().setKnownColor(ExcelColors.Black);

        // 保存為 .xlsx 文件
        wb.saveToFile("output/NewSpreadsheet.xlsx", FileFormat.Version2016);
    }
}