What Is jxl.jar 2.6.12

What is jxl.jar 2.6.12?

✍: fyicenter.com

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:


*      Copyright (C) 2005 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
* 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.read.biff;

import jxl.common.Logger;

import jxl.CellType;
import jxl.ErrorCell;
import jxl.ErrorFormulaCell;
import jxl.biff.FormattingRecords;
import jxl.biff.FormulaData;
import jxl.biff.IntegerHelper;
import jxl.biff.WorkbookMethods;
import jxl.biff.formula.ExternalSheet;
import jxl.biff.formula.FormulaErrorCode;
import jxl.biff.formula.FormulaException;
import jxl.biff.formula.FormulaParser;

 * A number formula record, manufactured out of the Shared Formula
 * "optimization"
public class SharedErrorFormulaRecord extends BaseSharedFormulaRecord
  implements ErrorCell, FormulaData, ErrorFormulaCell
   * The logger
  private static Logger logger = 

   * The error code of this cell
  private int errorCode;

   * The raw data
  private byte[] data;

   * The error code
  private FormulaErrorCode error;

   * Constructs this number
   * @param t the data
   * @param excelFile the excel biff data
   * @param v the errorCode
   * @param fr the formatting records
   * @param es the external sheet
   * @param nt the name table
   * @param si the sheet
  public SharedErrorFormulaRecord(Record t,
                                  File excelFile,
                                  int ec,
                                  FormattingRecords fr,
                                  ExternalSheet es,
                                  WorkbookMethods nt,
                                  SheetImpl si)
    super(t, fr, es, nt, si, excelFile.getPos());
    errorCode = ec;

   * Interface method which gets the error code for this cell.  If this cell
   * does not represent an error, then it returns 0.  Always use the
   * method isError() to  determine this prior to calling this method
   * @return the error code if this cell contains an error, 0 otherwise
  public int getErrorCode()
    return errorCode;

   * Returns the numerical value as a string
   * @return The numerical value of the formula as a string
  public String getContents()
    if (error == null)
      error = FormulaErrorCode.getErrorCode(errorCode);

    return error != FormulaErrorCode.UNKNOWN ? 
      error.getDescription() : "ERROR " + errorCode;

   * Accessor for the cell type
   * @return the cell type
  public CellType getType()
    return CellType.FORMULA_ERROR;

   * Gets the raw bytes for the formula.  This will include the
   * parsed tokens array.  Used when copying spreadsheets
   * @return the raw record data
   * @exception FormulaException
  public byte[] getFormulaData() throws FormulaException
    if (!getSheet().getWorkbookBof().isBiff8())
      throw new FormulaException(FormulaException.BIFF8_SUPPORTED);

    // Get the tokens, taking into account the mapping from shared
    // formula specific values into normal values
    FormulaParser fp = new FormulaParser
      (getTokens(), this,
       getExternalSheet(), getNameTable(),
    byte[] rpnTokens = fp.getBytes();

    byte[] data = new byte[rpnTokens.length + 22];

    // Set the standard info for this cell
    IntegerHelper.getTwoBytes(getRow(), data, 0);
    IntegerHelper.getTwoBytes(getColumn(), data, 2);
    IntegerHelper.getTwoBytes(getXFIndex(), data, 4);

    data[6] = (byte) 0x02; // indicates this cell is an error value
    data[8] = (byte) errorCode; 
    data[12] = (byte) 0xff;
    data[13] = (byte) 0xff;

    // Now copy in the parsed tokens
    System.arraycopy(rpnTokens, 0, data, 22, rpnTokens.length);
    IntegerHelper.getTwoBytes(rpnTokens.length, data, 20);

    // Lop off the standard information
    byte[] d = new byte[data.length - 6];
    System.arraycopy(data, 6, d, 0, data.length - 6);

    return d;



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


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

2017-06-09, 69484👍, 6💬