The maximum length of cell contents (text) is 32,767 characters java 导出-优快云博客

本文链接：https://blog.youkuaiyun.com/zhl_BeginLife/article/details/122090616

本文介绍了org.apache.poi.ss包下的SpreadsheetVersion枚举类，该类定义了Excel不同版本的最大行数、最大列数等属性。通过此枚举可以了解Excel97及Excel2007版本的文件限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

新建org.apache.poi.ss.SpreadsheetVersion 改成下面的模样，然后重启完毕。

//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by Fernflower decompiler)
//

package org.apache.poi.ss;

import org.apache.poi.ss.util.CellReference;

public enum SpreadsheetVersion {
    EXCEL97(65536, 256, 30, 3, Integer.MAX_VALUE),
    EXCEL2007(1048576, 16384, 255, 2147483647, Integer.MAX_VALUE);

    private final int _maxRows;
    private final int _maxColumns;
    private final int _maxFunctionArgs;
    private final int _maxCondFormats;
    private final int _maxTextLength;

    private SpreadsheetVersion(int maxRows, int maxColumns, int maxFunctionArgs, int maxCondFormats, int maxText) {
        this._maxRows = maxRows;
        this._maxColumns = maxColumns;
        this._maxFunctionArgs = maxFunctionArgs;
        this._maxCondFormats = maxCondFormats;
        this._maxTextLength = maxText;
    }

    public int getMaxRows() {
        return this._maxRows;
    }

    public int getLastRowIndex() {
        return this._maxRows - 1;
    }

    public int getMaxColumns() {
        return this._maxColumns;
    }

    public int getLastColumnIndex() {
        return this._maxColumns - 1;
    }

    public int getMaxFunctionArgs() {
        return this._maxFunctionArgs;
    }

    public int getMaxConditionalFormats() {
        return this._maxCondFormats;
    }

    public String getLastColumnName() {
        return CellReference.convertNumToColString(this.getLastColumnIndex());
    }

    public int getMaxTextLength() {
        return this._maxTextLength;
    }
}