The maximum length of cell contents (text) is 32,767 characters java 导出

最新推荐文章于 2024-04-12 11:12:38 发布

原创最新推荐文章于 2024-04-12 11:12:38 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #开发语言 #后端

uap开发专栏收录该内容

2 篇文章

订阅专栏

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

新建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;
    }
}