<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.free</artifactId>
    <version>5.3.0</version>
</dependency>

import com.spire.xls.*;

public class WriteTextNumber {

    public static void main(String[] args) {

        // 創(chuàng)建一個(gè)Excel工作簿
        Workbook workbook = new Workbook();

        // 獲取其中第一張工作表
        Worksheet worksheet = workbook.getWorksheets().get(0);

        // 寫(xiě)入數(shù)據(jù)到指定單元格
        worksheet.get("A1").setText("考號(hào)");
        worksheet.get("B1").setText("學(xué)生姓名");
        worksheet.get("C1").setValue("所在班級(jí)");
        worksheet.get("D1").setValue("考試成績(jī)");

        worksheet.get("A2").setValue("TS001");
        worksheet.get("B2").setText("陳國(guó)柏");
        worksheet.get("C2").setText("5班");
        worksheet.get("D2").setNumberValue(97);

        worksheet.get("A3").setValue("TS002");
        worksheet.get("B3").setText("易江維");
        worksheet.get("C3").setText("2班");
        worksheet.get("D3").setNumberValue(92);

        //設(shè)置字體樣式
        worksheet.get("A1:D1").getStyle().getFont().isBold(true);
        worksheet.get("A1:D3").getStyle().getFont().setSize(11);
        worksheet.get("A1:D3").getStyle().getFont().setFontName("宋體");

        // 保存Excel文件
        workbook.saveToFile("寫(xiě)入數(shù)據(jù)到單元格.xlsx", ExcelVersion.Version2016);
    }
}

import com.spire.xls.*;

public class WriteArrayToWorksheet {

    public static void main(String[] args) {

        // 創(chuàng)建一個(gè)Excel工作簿
        Workbook workbook = new Workbook();

        // 獲取其中第一張工作表
        Worksheet worksheet = workbook.getWorksheets().get(0);

        // 創(chuàng)建一個(gè)二維數(shù)組
        String[][] twoDimensionalArray = new String[][]{
                {"統(tǒng)計(jì)年份", "城市", "銷售額", "增長(zhǎng)率"},
                {"2021", "上海", "150萬(wàn)", "55%"},
                {"2021", "杭州", "80萬(wàn)", "-12%"},
                {"2021", "北京", "100萬(wàn)", "20%"}
        };

        // 將數(shù)組寫(xiě)入工作表指定位置
        worksheet.insertArray(twoDimensionalArray, 1, 1);

        //設(shè)置字體樣式
        worksheet.get("A1:D1").getStyle().getFont().isBold(true);
        worksheet.get("A1:D4").getStyle().getFont().setSize(11);
        worksheet.get("A1:D4").getStyle().getFont().setFontName("宋體");

        // 保存Excel文件
        workbook.saveToFile("寫(xiě)入數(shù)組.xlsx", ExcelVersion.Version2016);
    }
}

import com.spire.data.table.DataRow;
import com.spire.data.table.DataTable;
import com.spire.xls.*;

import java.text.DecimalFormat;

public class WriteDataTableToWorksheet {

    public static void main(String[] args) throws Exception {

        // 創(chuàng)建一個(gè)Excel工作簿
        Workbook workbook = new Workbook();

        // 獲取其中第一張工作表
        Worksheet worksheet = workbook.getWorksheets().get(0);

        // 創(chuàng)建DataTable對(duì)象
        DataTable dataTable = new DataTable();
        dataTable.getColumns().add("編碼", Integer.class);
        dataTable.getColumns().add("產(chǎn)品", String.class);
        dataTable.getColumns().add("單價(jià)", DecimalFormat.class);

        // 創(chuàng)建行并添加數(shù)據(jù)
        DataRow dr = dataTable.newRow();
        dr.setInt(0, 110600015);
        dr.setString(1,"數(shù)據(jù)線");
        dr.setString(2,"8.5");
        dataTable.getRows().add(dr);

        dr = dataTable.newRow();
        dr.setInt(0,110600037);
        dr.setString(1,"鼠標(biāo)");
        dr.setString(2,"29.9");
        dataTable.getRows().add(dr);

        dr = dataTable.newRow();
        dr.setInt(0,110600021);
        dr.setString(1,"網(wǎng)線");
        dr.setString(2,"15.5");
        dataTable.getRows().add(dr);

        // 將datatable中的數(shù)據(jù)寫(xiě)入工作表
        worksheet.insertDataTable(dataTable,true,1,1,true);

        //設(shè)置字體樣式
        worksheet.get("A1:D1").getStyle().getFont().isBold(true);
        worksheet.get("A1:D4").getStyle().getFont().setSize(11);
        worksheet.get("A1:D4").getStyle().getFont().setFontName("宋體");

        // 保存Excel文件
        workbook.saveToFile("寫(xiě)入DataTable.xlsx", ExcelVersion.Version2016);
    }
}