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:


/* ====================================================================
   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


   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.hssf.record;

import java.util.ArrayList;
import java.util.Map;
import java.util.function.Supplier;
import java.util.stream.Stream;

import org.apache.poi.common.usermodel.GenericRecord;
import org.apache.poi.hssf.record.cont.ContinuableRecord;
import org.apache.poi.hssf.record.cont.ContinuableRecordOutput;
import org.apache.poi.util.GenericRecordUtil;
import org.apache.poi.util.LittleEndianOutput;

 * Extended Static String Table (0x00FF)<p>
 * This record is used for a quick lookup into the SST record. This record breaks the SST table
 * into a set of buckets. The offsets to these buckets within the SST record are kept as well as
 * the position relative to the start of the SST record.
public final class ExtSSTRecord extends ContinuableRecord {
    public static final short sid = 0x00FF;
    public static final int DEFAULT_BUCKET_SIZE = 8;
    //Can't seem to find this documented but from the biffviewer it is clear that
    //Excel only records the indexes for the first 128 buckets.
    public static final int MAX_BUCKETS = 128;

    public static final class InfoSubRecord implements GenericRecord {
        public static final int ENCODED_SIZE = 8;
        private int field_1_stream_pos;          // stream pointer to the SST record
        private int field_2_bucket_sst_offset;   // don't really understand this yet.
        /** unused - supposed to be zero */
        private short field_3_zero;

         * Creates new ExtSSTInfoSubRecord
         * @param streamPos stream pointer to the SST record
         * @param bucketSstOffset ... don't really understand this yet
        public InfoSubRecord(int streamPos, int bucketSstOffset) {
            field_1_stream_pos        = streamPos;
            field_2_bucket_sst_offset = bucketSstOffset;

        public InfoSubRecord(InfoSubRecord other) {
            field_1_stream_pos        = other.field_1_stream_pos;
            field_2_bucket_sst_offset = other.field_2_bucket_sst_offset;
            field_3_zero              = other.field_3_zero;

        public InfoSubRecord(RecordInputStream in) {
            field_1_stream_pos        = in.readInt();
            field_2_bucket_sst_offset = in.readShort();
            field_3_zero              = in.readShort();

        public int getStreamPos() {
            return field_1_stream_pos;

        public int getBucketSSTOffset() {
            return field_2_bucket_sst_offset;

        public void serialize(LittleEndianOutput out) {

        public Map<String, Supplier<?>> getGenericProperties() {
            return GenericRecordUtil.getGenericProperties(
                "streamPos", this::getStreamPos,
                "bucketSSTOffset", this::getBucketSSTOffset

    private short _stringsPerBucket;
    private InfoSubRecord[] _sstInfos;

    public ExtSSTRecord() {
        _stringsPerBucket = DEFAULT_BUCKET_SIZE;
        _sstInfos = new InfoSubRecord[0];

    public ExtSSTRecord(ExtSSTRecord other) {
        _stringsPerBucket = other._stringsPerBucket;
        _sstInfos = (other._sstInfos == null) ? null
            : Stream.of(other._sstInfos).map(InfoSubRecord::new).toArray(InfoSubRecord[]::new);

    public ExtSSTRecord(RecordInputStream in) {
        _stringsPerBucket = in.readShort();

        int nInfos = in.remaining() / InfoSubRecord.ENCODED_SIZE;
        ArrayList<InfoSubRecord> lst = new ArrayList<>(nInfos);

        while (in.available() > 0) {
            InfoSubRecord info = new InfoSubRecord(in);

            if(in.available() == 0 && in.hasNextRecord() && in.getNextSid() == ContinueRecord.sid) {
        _sstInfos = lst.toArray(new InfoSubRecord[0]);

    public void setNumStringsPerBucket(short numStrings) {
        _stringsPerBucket = numStrings;

    public void serialize(ContinuableRecordOutput out) {
        for (InfoSubRecord sstInfo : _sstInfos) {

    int getDataSize() {
        return 2 + InfoSubRecord.ENCODED_SIZE*_sstInfos.length;

    InfoSubRecord[] getInfoSubRecords() {
        return _sstInfos;

    public static int getNumberOfInfoRecsForStrings(int numStrings) {
      int infoRecs = (numStrings / DEFAULT_BUCKET_SIZE);
      if ((numStrings % DEFAULT_BUCKET_SIZE) != 0)
        infoRecs ++;
      //Excel seems to max out after 128 info records.
      //This isn't really documented anywhere...
      if (infoRecs > MAX_BUCKETS)
        infoRecs = MAX_BUCKETS;
      return infoRecs;

     * Given a number of strings (in the sst), returns the size of the extsst record
     * @param numStrings the number of strings
     * @return the size of the extsst record
    public static int getRecordSizeForStrings(int numStrings) {
        return 4 + 2 + getNumberOfInfoRecsForStrings(numStrings) * 8;

    public short getSid() {
        return sid;

    public void setBucketOffsets(int[] bucketAbsoluteOffsets, int[] bucketRelativeOffsets) {
        // TODO - replace no-arg constructor with this logic
        _sstInfos = new InfoSubRecord[bucketAbsoluteOffsets.length];
        for (int i = 0; i < bucketAbsoluteOffsets.length; i++) {
            _sstInfos[i] = new InfoSubRecord(bucketAbsoluteOffsets[i], bucketRelativeOffsets[i]);

    public ExtSSTRecord copy() {
        return new ExtSSTRecord(this);

    public HSSFRecordTypes getGenericRecordType() {
        return HSSFRecordTypes.EXT_SST;

    public Map<String, Supplier<?>> getGenericProperties() {
        return GenericRecordUtil.getGenericProperties(
            "dataSize", this::getDataSize,
            "infoSubRecords", this::getInfoSubRecords


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


What Is poi-ooxml-5.2.3.jar?

What Is poi-bin-5.2.3-20220909.zip?

Downloading and Installing Apache POI Java Library

⇑⇑ FAQ for Apache POI (Poor Obfuscation Implementation)

2017-04-04, 55598👍, 0💬