Excel(4) : 修改xls

 参考 : https://blog.csdn.net/weixin_42394206/article/details/114055674

maven坐标

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

import jxl.Workbook;
import jxl.write.*;

import java.io.File;


public class ExcelUtil {


    private static final File file = new File("/Users/ly/files/t1.xls");

    public static void main(String[] args) {
        modifyExcel(0, 1, 1, "修改111");
    }

    public static void modifyExcel(int SheetNo, int lieshu, int hangshu, String value) {
        try {
            Workbook rwb = Workbook.getWorkbook(file);
            WritableWorkbook wwb = Workbook.createWorkbook(file, rwb);// copy
            WritableSheet ws = wwb.getSheet(SheetNo);
            WritableFont font = new WritableFont(WritableFont.createFont("宋体"), 10, WritableFont.NO_BOLD);
            WritableCellFormat format = new WritableCellFormat(font);
            Label labelCF = new Label(lieshu, hangshu, value, format);
            ws.addCell(labelCF);
            wwb.write();
            wwb.close();
            rwb.close();
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("您是否打开了excel文件！请关闭后再试。");
        }

    }
}