Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
What Is poi-5.2.3.jar?
What Is poi-5.2.3.jar?
✍: FYIcenter.com
poi-5.2.3.jar is one of the JAR files for Apache POI 5.2.3, which provides an API for Microsoft document files of Word, Excel, PowerPoint, and Visio.
poi-5.2.3.jar supports Apache POI components that read and write Microsoft's OLE 2 Compound document format, which is used in early versions of Microsoft Office tools like Word 97, Excel 97, PowerPoint 97, etc.
poi-5.2.3.jar is distributed as part of the poi-bin-5.2.3-20220909.zip download file.
JAR File Size and Download Location:
JAR name: poi-5.2.3.jar Target JDK version: 9 File name: poi.jar, poi-5.2.3.jar File size: 2964641 bytes Release date: 09-09-2022 Download: Apache POI Website
Here are Java Source Code files for poi-5.2.3.jar:
⏎ org/apache/poi/ss/SpreadsheetVersion.java
/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ package org.apache.poi.ss; import org.apache.poi.ss.util.CellReference; /** * This enum allows spreadsheets from multiple Excel versions to be handled by the common code. * <p>Properties of this enum correspond to attributes of the <i>spreadsheet</i> that are easily * discernable to the user. It is not intended to deal with low-level issues like file formats. */ public enum SpreadsheetVersion { /** * Excel97 format aka BIFF8 * <ul> * <li>The total number of available rows is 64k (2^16)</li> * <li>The total number of available columns is 256 (2^8)</li> * <li>The maximum number of arguments to a function is 30</li> * <li>Number of conditional format conditions on a cell is 3</li> * <li>Number of cell styles is 4000</li> * <li>Length of text cell contents is 32767</li> * </ul> */ EXCEL97(0x10000, 0x0100, 30, 3, 4000, 32767), /** * Excel2007 * * <ul> * <li>The total number of available rows is 1M (2^20)</li> * <li>The total number of available columns is 16K (2^14)</li> * <li>The maximum number of arguments to a function is 255</li> * <li>Number of conditional format conditions on a cell is unlimited * (actually limited by available memory in Excel)</li> * <li>Number of cell styles is 64000</li> * <li>Length of text cell contents is 32767</li> * </ul> */ EXCEL2007(0x100000, 0x4000, 255, Integer.MAX_VALUE, 64000, 32767); private final int _maxRows; private final int _maxColumns; private final int _maxFunctionArgs; private final int _maxCondFormats; private final int _maxCellStyles; private final int _maxTextLength; SpreadsheetVersion(int maxRows, int maxColumns, int maxFunctionArgs, int maxCondFormats, int maxCellStyles, int maxText) { _maxRows = maxRows; _maxColumns = maxColumns; _maxFunctionArgs = maxFunctionArgs; _maxCondFormats = maxCondFormats; _maxCellStyles = maxCellStyles; _maxTextLength = maxText; } /** * @return the maximum number of usable rows in each spreadsheet */ public int getMaxRows() { return _maxRows; } /** * @return the last (maximum) valid row index, equals to {@code getMaxRows() - 1 } */ public int getLastRowIndex() { return _maxRows - 1; } /** * @return the maximum number of usable columns in each spreadsheet */ public int getMaxColumns() { return _maxColumns; } /** * @return the last (maximum) valid column index, equals to {@code getMaxColumns() - 1 } */ public int getLastColumnIndex() { return _maxColumns - 1; } /** * @return the maximum number arguments that can be passed to a multi-arg function (e.g. COUNTIF) */ public int getMaxFunctionArgs() { return _maxFunctionArgs; } /** * @return the maximum number of conditional format conditions on a cell */ public int getMaxConditionalFormats() { return _maxCondFormats; } /** * @return the maximum number of cell styles per spreadsheet */ public int getMaxCellStyles() { return _maxCellStyles; } /** * * @return the last valid column index in a ALPHA-26 representation * ({@code IV} or {@code XFD}). */ public String getLastColumnName() { return CellReference.convertNumToColString(getLastColumnIndex()); } /** * @return the maximum length of a text cell */ public int getMaxTextLength() { return _maxTextLength; } }
⏎ org/apache/poi/ss/SpreadsheetVersion.java
Or download all of them as a single archive file:
File name: poi-5.2.3-src.zip File size: 2479830 bytes Release date: 2022-09-09 Download
⇒ What Is poi-ooxml-5.2.3.jar?
⇐ What Is poi-bin-5.2.3-20220909.zip?
2017-04-04, 56986👍, 0💬
Popular Posts:
commons-lang-2.6.jar is the JAR file for Apache Commons Lang 2.6, which provides a host of helper ut...
Swingx is the SwingLabs Swing Component Extensions. JAR File Size and Download Location: File name: ...
Commons Pool provides an Object-pooling API, with three major aspects: 1. A generic object pool inte...
JDK 17 jdk.compiler.jmod is the JMOD file for JDK 17 Compiler tool, which can be invoked by the "jav...
A stream buffer is a stream-based representation of an XML infoset in Java. Stream buffers are desig...