What is jxl.jar 2.6.12?

jxl.jar 2.6.12 is the JAR file for Java Excel API 2.6.12, which is a Java library for reading, writing and modifying Microsoft Excel spreadsheet files.

JAR File Size and Download Location:

JAR name: jxl-2.6.12.jar
Target JDK version: 1.6
Dependency: None

File name: jxl.jar
File size: 725735 bytes
Release date: 24-Oct-2009
Download: Java Excel API Website.

Here are Java Source Code files for jxl-2.6.12.jar:

⏎ jxl/write/biff/SupbookRecord.java

/*********************************************************************
*
*      Copyright (C) 2002 Andrew Khan
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
***************************************************************************/

package jxl.write.biff;

import jxl.common.Assert;
import jxl.common.Logger;

import jxl.WorkbookSettings;
import jxl.biff.EncodedURLHelper;
import jxl.biff.IntegerHelper;
import jxl.biff.StringHelper;
import jxl.biff.Type;
import jxl.biff.WritableRecordData;

/**
 * Stores the supporting workbook information.  For files written by
 * JExcelApi this will only reference internal sheets
 */
class SupbookRecord extends WritableRecordData
{
  /**
   * The logger
   */
  private static Logger logger = Logger.getLogger(SupbookRecord.class);

  /**
   * The type of this supbook record
   */
  private SupbookType type;

  /**
   * The data to be written to the binary file
   */
  private byte[] data;

  /**
   * The number of sheets - internal & external supbooks only
   */
  private int numSheets;

  /**
   * The name of the external file
   */
  private String fileName;

  /**
   * The names of the external sheets
   */
  private String[] sheetNames;

  /**
   * The workbook settings
   */
  private WorkbookSettings workbookSettings;

  /**
   * The type of supbook this refers to
   */
  private static class SupbookType {};

  public final static SupbookType INTERNAL = new SupbookType();
  public final static SupbookType EXTERNAL = new SupbookType();
  public final static SupbookType ADDIN    = new SupbookType();
  public final static SupbookType LINK     = new SupbookType();
  public final static SupbookType UNKNOWN  = new SupbookType();
  
  /**
   * Constructor for add in function names
   */
  public SupbookRecord()
  {
    super(Type.SUPBOOK);
    type = ADDIN;
  }

  /**
   * Constructor for internal sheets
   */
  public SupbookRecord(int sheets, WorkbookSettings ws)
  {
    super(Type.SUPBOOK);

    numSheets = sheets;
    type = INTERNAL;
    workbookSettings = ws;
  }

  /**
   * Constructor for external sheets
   *
   * @param fn the filename of the external supbook
   * @param ws the workbook settings
   */
  public SupbookRecord(String fn, WorkbookSettings ws)
  {
    super(Type.SUPBOOK);

    fileName = fn;
    numSheets = 1;
    sheetNames = new String[0];
    workbookSettings = ws;

    type = EXTERNAL;
  }

  /**
   * Constructor used when copying from an external workbook
   */
  public SupbookRecord(jxl.read.biff.SupbookRecord sr, WorkbookSettings ws)
  {
    super(Type.SUPBOOK);

    workbookSettings = ws;
    if (sr.getType() == sr.INTERNAL)
    {
      type = INTERNAL;
      numSheets = sr.getNumberOfSheets();
    }
    else if (sr.getType() == sr.EXTERNAL)
    {
      type = EXTERNAL;
      numSheets = sr.getNumberOfSheets();
      fileName = sr.getFileName();
      sheetNames = new String[numSheets];

      for (int i = 0; i < numSheets; i++)
      {
        sheetNames[i] = sr.getSheetName(i);
      }
    }

    if (sr.getType() == sr.ADDIN)
    {
      logger.warn("Supbook type is addin");
    }
  }

  /**
   * Initializes an internal supbook record
   * 
   * @param sr the read supbook record to copy from
   */
  private void initInternal(jxl.read.biff.SupbookRecord sr)
  {
    numSheets = sr.getNumberOfSheets();
    initInternal();
  }

  /**
   * Initializes an internal supbook record
   */
  private void initInternal()
  {
    data = new byte[4];

    IntegerHelper.getTwoBytes(numSheets, data, 0);
    data[2] = 0x1;
    data[3] = 0x4;    
    type = INTERNAL;
  }

  /**
   * Adjust the number of internal sheets.  Called by WritableSheet when
   * a sheet is added or or removed to the workbook
   *
   * @param sheets the new number of sheets
   */
  void adjustInternal(int sheets)
  {
    Assert.verify(type == INTERNAL);
    numSheets = sheets;
    initInternal();
  }

  /**
   * Initializes an external supbook record
   */
  private void initExternal()
  {
    int totalSheetNameLength = 0;
    for (int i = 0; i < numSheets; i++)
    {
      totalSheetNameLength += sheetNames[i].length();
    }

    byte[] fileNameData = EncodedURLHelper.getEncodedURL(fileName, 
                                                         workbookSettings);
    int dataLength = 2 + // numsheets
      4 + fileNameData.length +
      numSheets * 3 + totalSheetNameLength * 2;
      
    data = new byte[dataLength];

    IntegerHelper.getTwoBytes(numSheets, data, 0);
    
    // Add in the file name.  Precede with a byte denoting that it is a 
    // file name
    int pos = 2;
    IntegerHelper.getTwoBytes(fileNameData.length+1, data, pos);
    data[pos+2] = 0; // ascii indicator
    data[pos+3] = 1; // file name indicator
    System.arraycopy(fileNameData, 0, data, pos+4, fileNameData.length);

    pos += 4 + fileNameData.length;

    // Get the sheet names
    for (int i = 0; i < sheetNames.length; i++)
    {
      IntegerHelper.getTwoBytes(sheetNames[i].length(), data, pos);
      data[pos+2] = 1; // unicode indicator
      StringHelper.getUnicodeBytes(sheetNames[i], data, pos+3);
      pos += 3 + sheetNames[i].length() * 2;
    }
  }

  /**
   * Initializes the supbook record for add in functions
   */
  private void initAddin()
  {
    data = new byte[] {0x1, 0x0, 0x1, 0x3a};
  }

  /**
   * The binary data to be written out
   * 
   * @return the binary data
   */
  public byte[] getData()
  {
    if (type == INTERNAL)
    {
      initInternal();
    }
    else if (type == EXTERNAL)
    {
      initExternal();
    }
    else if (type == ADDIN)
    {
      initAddin();
    }
    else
    {
      logger.warn("unsupported supbook type - defaulting to internal");
      initInternal();
    }

    return data;
  }

  /**
   * Gets the type of this supbook record
   * 
   * @return the type of this supbook
   */
  public SupbookType getType()
  {
    return type;
  }

  /**
   * Gets the number of sheets.  This will only be non-zero for internal
   * and external supbooks
   *
   * @return the number of sheets
   */
  public int getNumberOfSheets()
  {
    return numSheets;
  }

  /**
   * Accessor for the file name
   *
   * @return the file name
   */
  public String getFileName()
  {
    return fileName;
  }

  /**
   * Adds the worksheet name to this supbook
   *
   * @param name the worksheet name
   * @return the index of this sheet in the supbook record
   */
  public int getSheetIndex(String s)
  {
    boolean found = false;
    int sheetIndex = 0;
    for (int i = 0; i < sheetNames.length && !found; i++)
    {
      if (sheetNames[i].equals(s))
      {
        found = true;
        sheetIndex = 0;
      }
    }

    if (found)
    {
      return sheetIndex;
    }

    // Grow the array
    String[] names = new String[sheetNames.length + 1];
    System.arraycopy(sheetNames, 0, names, 0, sheetNames.length);
    names[sheetNames.length] = s;
    sheetNames = names;
    return sheetNames.length - 1;
  }

  /**
   * Accessor for the sheet name
   * 
   * @param s the sheet index
   */
  public String getSheetName(int s)
  {
    return sheetNames[s];
  }
}

⏎ jxl/write/biff/SupbookRecord.java

Or download all of them as a single archive file:

File name: jxl-2.6.12-src.zip
File size: 824057 bytes
Release date: 2009-10-24
Download 

⇒ Demo Programs for jxl.jar

⇐ What Is jexcelapi_2_6_12.zip

⇑ Download Java Excel API jxl.jar

⇑⇑ FAQ for Java Excel API jxl.jar