<dependency>
    <groupId>net.sourceforge.jexcelapi</groupId>
    <artifactId>jxl</artifactId>
    <version>2.6.12</version>
</dependency>

import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
 
public class CreateExcelExample {
    public static void main(String[] args) {
        try {
            // 創(chuàng)建一個(gè)可寫(xiě)的工作簿對(duì)象
            WritableWorkbook workbook = Workbook.createWorkbook(new File("example.xls"));
 
            // 創(chuàng)建一個(gè)工作表，參數(shù)為工作表名稱和工作表索引
            WritableSheet sheet = workbook.createSheet("Sheet1", 0);
 
            // 在工作表的指定單元格添加數(shù)據(jù)
            Label label = new Label(0, 0, "Hello, jxl!");
            sheet.addCell(label);
 
            // 寫(xiě)入數(shù)據(jù)并關(guān)閉工作簿
            workbook.write();
            workbook.close();
 
            System.out.println("Excel 文件創(chuàng)建成功！");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Excel 文件創(chuàng)建失?。? + e.getMessage());
        }
    }
}

import java.io.File;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
 
public class ReadExcelExample {
    public static void main(String[] args) {
        try {
            // 創(chuàng)建一個(gè)工作簿對(duì)象，從指定文件讀取數(shù)據(jù)
            Workbook workbook = Workbook.getWorkbook(new File("example.xls"));
 
            // 獲取第一個(gè)工作表
            Sheet sheet = workbook.getSheet(0);
 
            // 獲取工作表的行數(shù)和列數(shù)
            int rows = sheet.getRows();
            int cols = sheet.getColumns();
 
            // 遍歷工作表的單元格并輸出內(nèi)容
            for (int i = 0; i < rows; i++) {
                for (int j = 0; j < cols; j++) {
                    Cell cell = sheet.getCell(j, i);
                    System.out.print(cell.getContents() + "\t");
                }
                System.out.println();
            }
 
            // 關(guān)閉工作簿
            workbook.close();
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Excel 文件讀取失?。? + e.getMessage());
        }
    }
}

import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCell;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
 
public class ModifyExcelExample {
    public static void main(String[] args) {
        try {
            // 打開(kāi)現(xiàn)有的工作簿
            Workbook existingWorkbook = Workbook.getWorkbook(new File("example.xls"));
 
            // 創(chuàng)建一個(gè)可寫(xiě)的工作簿對(duì)象，基于現(xiàn)有的工作簿
            WritableWorkbook workbook = Workbook.createWorkbook(new File("modified_example.xls"), existingWorkbook);
 
            // 獲取第一個(gè)工作表
            WritableSheet sheet = workbook.getSheet(0);
 
            // 修改指定單元格的內(nèi)容
            WritableCell cell = sheet.getWritableCell(0, 0);
            if (cell instanceof Label) {
                Label label = (Label) cell;
                label.setString("Modified Content");
            }
 
            // 寫(xiě)入數(shù)據(jù)并關(guān)閉工作簿
            workbook.write();
            workbook.close();
            existingWorkbook.close();
 
            System.out.println("Excel 文件修改成功！");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Excel 文件修改失?。? + e.getMessage());
        }
    }
}