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/demo/BiffDump.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.demo;


import java.io.BufferedWriter;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.io.OutputStreamWriter;

import java.util.HashMap;

import jxl.WorkbookSettings;
import jxl.biff.Type;
import jxl.read.biff.BiffException;
import jxl.read.biff.BiffRecordReader;
import jxl.read.biff.File;
import jxl.read.biff.Record;

/**
 * Generates a biff dump of the specified excel file
 */
class BiffDump
{
  private BufferedWriter writer;
  private BiffRecordReader reader;

  private HashMap recordNames;

  private int xfIndex;
  private int fontIndex;
  private int bofs;

  private static final int bytesPerLine = 16;

  /**
   * Constructor
   *
   * @param file the file
   * @param os the output stream
   * @exception IOException 
   * @exception BiffException
   */
  public BiffDump(java.io.File file, OutputStream os) 
    throws IOException, BiffException
  {
    writer = new BufferedWriter(new OutputStreamWriter(os));
    FileInputStream fis = new FileInputStream(file);
    File f = new File(fis, new WorkbookSettings());
    reader = new BiffRecordReader(f);

    buildNameHash();
    dump();

    writer.flush();
    writer.close();
    fis.close();
  }

  /**
   * Builds the hashmap of record names
   */
  private void buildNameHash()
  {
    recordNames = new HashMap(50);

    recordNames.put(Type.BOF, "BOF");
    recordNames.put(Type.EOF, "EOF");
    recordNames.put(Type.FONT, "FONT");
    recordNames.put(Type.SST, "SST");
    recordNames.put(Type.LABELSST, "LABELSST");
    recordNames.put(Type.WRITEACCESS, "WRITEACCESS");
    recordNames.put(Type.FORMULA, "FORMULA");
    recordNames.put(Type.FORMULA2, "FORMULA");
    recordNames.put(Type.XF, "XF");
    recordNames.put(Type.MULRK, "MULRK");
    recordNames.put(Type.NUMBER, "NUMBER");
    recordNames.put(Type.BOUNDSHEET, "BOUNDSHEET");
    recordNames.put(Type.CONTINUE, "CONTINUE");
    recordNames.put(Type.FORMAT, "FORMAT");
    recordNames.put(Type.EXTERNSHEET, "EXTERNSHEET");
    recordNames.put(Type.INDEX, "INDEX");
    recordNames.put(Type.DIMENSION, "DIMENSION");
    recordNames.put(Type.ROW, "ROW");
    recordNames.put(Type.DBCELL, "DBCELL");
    recordNames.put(Type.BLANK, "BLANK");
    recordNames.put(Type.MULBLANK, "MULBLANK");
    recordNames.put(Type.RK, "RK");
    recordNames.put(Type.RK2, "RK");
    recordNames.put(Type.COLINFO, "COLINFO");
    recordNames.put(Type.LABEL, "LABEL");
    recordNames.put(Type.SHAREDFORMULA, "SHAREDFORMULA");
    recordNames.put(Type.CODEPAGE, "CODEPAGE");
    recordNames.put(Type.WINDOW1, "WINDOW1");
    recordNames.put(Type.WINDOW2, "WINDOW2");
    recordNames.put(Type.MERGEDCELLS, "MERGEDCELLS");
    recordNames.put(Type.HLINK, "HLINK");
    recordNames.put(Type.HEADER, "HEADER");
    recordNames.put(Type.FOOTER, "FOOTER");
    recordNames.put(Type.INTERFACEHDR, "INTERFACEHDR");
    recordNames.put(Type.MMS, "MMS");
    recordNames.put(Type.INTERFACEEND, "INTERFACEEND");
    recordNames.put(Type.DSF, "DSF");
    recordNames.put(Type.FNGROUPCOUNT, "FNGROUPCOUNT");
    recordNames.put(Type.COUNTRY, "COUNTRY");
    recordNames.put(Type.TABID, "TABID");
    recordNames.put(Type.PROTECT, "PROTECT");
    recordNames.put(Type.SCENPROTECT, "SCENPROTECT");
    recordNames.put(Type.OBJPROTECT, "OBJPROTECT");
    recordNames.put(Type.WINDOWPROTECT, "WINDOWPROTECT");
    recordNames.put(Type.PASSWORD, "PASSWORD");
    recordNames.put(Type.PROT4REV, "PROT4REV");
    recordNames.put(Type.PROT4REVPASS, "PROT4REVPASS");
    recordNames.put(Type.BACKUP, "BACKUP");
    recordNames.put(Type.HIDEOBJ, "HIDEOBJ");
    recordNames.put(Type.NINETEENFOUR, "1904");
    recordNames.put(Type.PRECISION, "PRECISION");
    recordNames.put(Type.BOOKBOOL, "BOOKBOOL");
    recordNames.put(Type.STYLE, "STYLE");
    recordNames.put(Type.EXTSST, "EXTSST");
    recordNames.put(Type.REFRESHALL, "REFRESHALL");
    recordNames.put(Type.CALCMODE, "CALCMODE");
    recordNames.put(Type.CALCCOUNT, "CALCCOUNT");
    recordNames.put(Type.NAME, "NAME");
    recordNames.put(Type.MSODRAWINGGROUP, "MSODRAWINGGROUP");
    recordNames.put(Type.MSODRAWING, "MSODRAWING");
    recordNames.put(Type.OBJ, "OBJ");
    recordNames.put(Type.USESELFS, "USESELFS");
    recordNames.put(Type.SUPBOOK, "SUPBOOK");
    recordNames.put(Type.LEFTMARGIN, "LEFTMARGIN");
    recordNames.put(Type.RIGHTMARGIN, "RIGHTMARGIN");
    recordNames.put(Type.TOPMARGIN, "TOPMARGIN");
    recordNames.put(Type.BOTTOMMARGIN, "BOTTOMMARGIN");
    recordNames.put(Type.HCENTER, "HCENTER");
    recordNames.put(Type.VCENTER, "VCENTER");
    recordNames.put(Type.ITERATION, "ITERATION");
    recordNames.put(Type.DELTA, "DELTA");
    recordNames.put(Type.SAVERECALC, "SAVERECALC");
    recordNames.put(Type.PRINTHEADERS, "PRINTHEADERS");
    recordNames.put(Type.PRINTGRIDLINES, "PRINTGRIDLINES");
    recordNames.put(Type.SETUP, "SETUP");
    recordNames.put(Type.SELECTION, "SELECTION");
    recordNames.put(Type.STRING, "STRING");
    recordNames.put(Type.FONTX, "FONTX");
    recordNames.put(Type.IFMT, "IFMT");
    recordNames.put(Type.WSBOOL, "WSBOOL");
    recordNames.put(Type.GRIDSET, "GRIDSET");
    recordNames.put(Type.REFMODE, "REFMODE");
    recordNames.put(Type.GUTS, "GUTS");
    recordNames.put(Type.EXTERNNAME, "EXTERNNAME");
    recordNames.put(Type.FBI, "FBI");
    recordNames.put(Type.CRN, "CRN");
    recordNames.put(Type.HORIZONTALPAGEBREAKS, "HORIZONTALPAGEBREAKS");
    recordNames.put(Type.VERTICALPAGEBREAKS, "VERTICALPAGEBREAKS");
    recordNames.put(Type.DEFAULTROWHEIGHT, "DEFAULTROWHEIGHT");
    recordNames.put(Type.TEMPLATE, "TEMPLATE");
    recordNames.put(Type.PANE, "PANE");
    recordNames.put(Type.SCL, "SCL");
    recordNames.put(Type.PALETTE, "PALETTE");
    recordNames.put(Type.PLS, "PLS");
    recordNames.put(Type.OBJPROJ, "OBJPROJ");
    recordNames.put(Type.DEFCOLWIDTH, "DEFCOLWIDTH");
    recordNames.put(Type.ARRAY, "ARRAY");
    recordNames.put(Type.WEIRD1, "WEIRD1");
    recordNames.put(Type.BOOLERR, "BOOLERR");
    recordNames.put(Type.SORT, "SORT");
    recordNames.put(Type.BUTTONPROPERTYSET, "BUTTONPROPERTYSET");
    recordNames.put(Type.NOTE, "NOTE");
    recordNames.put(Type.TXO, "TXO");
    recordNames.put(Type.DV, "DV");
    recordNames.put(Type.DVAL, "DVAL");
    recordNames.put(Type.SERIES, "SERIES");
    recordNames.put(Type.SERIESLIST, "SERIESLIST");
    recordNames.put(Type.SBASEREF, "SBASEREF");
    recordNames.put(Type.CONDFMT, "CONDFMT");
    recordNames.put(Type.CF, "CF");
    recordNames.put(Type.FILTERMODE, "FILTERMODE");
    recordNames.put(Type.AUTOFILTER, "AUTOFILTER");
    recordNames.put(Type.AUTOFILTERINFO, "AUTOFILTERINFO");
    recordNames.put(Type.XCT, "XCT");
    
    recordNames.put(Type.UNKNOWN, "???");
  }
  /**
   * Dumps out the contents of the excel file
   */
  private void dump() throws IOException
  {
    Record r = null;
    boolean cont = true;
    while (reader.hasNext() && cont)
    {
      r = reader.next();
      cont = writeRecord(r);
    }
  }

  /**
   * Writes out the biff record
   * @param r
   * @exception IOException if an error occurs
   */
  private boolean writeRecord(Record r)
    throws IOException
  {
    boolean cont = true;
    int pos = reader.getPos();
    int code = r.getCode();

    if (bofs == 0)
    {
      cont = (r.getType() == Type.BOF);
    }

    if (!cont)
    {
      return cont;
    }

    if (r.getType() == Type.BOF)
    {
      bofs++;
    }
    
    if (r.getType() == Type.EOF)
    {
      bofs--;
    }

    StringBuffer buf = new StringBuffer();

    // Write out the record header
    writeSixDigitValue(pos, buf);
    buf.append(" [");
    buf.append(recordNames.get(r.getType()));
    buf.append("]");
    buf.append("  (0x");
    buf.append(Integer.toHexString(code));
    buf.append(")");

    if (code == Type.XF.value)
    {
      buf.append(" (0x");
      buf.append(Integer.toHexString(xfIndex));
      buf.append(")");
      xfIndex++;
    }

    if (code == Type.FONT.value)
    {
      if (fontIndex == 4)
      {
        fontIndex++;
      }

      buf.append(" (0x");
      buf.append(Integer.toHexString(fontIndex));
      buf.append(")");
      fontIndex++;
    }

    writer.write(buf.toString());
    writer.newLine();

    byte[] standardData = new byte[4];
    standardData[0] = (byte) (code & 0xff);
    standardData[1] = (byte) ((code & 0xff00) >> 8);
    standardData[2] = (byte) (r.getLength() & 0xff);
    standardData[3] = (byte) ((r.getLength() & 0xff00) >> 8);
    byte[] recordData = r.getData();
    byte[] data = new byte[standardData.length + recordData.length];
    System.arraycopy(standardData, 0, data, 0, standardData.length);
    System.arraycopy(recordData, 0, data, 
                     standardData.length, recordData.length);

    int byteCount = 0;
    int lineBytes = 0;

    while (byteCount < data.length)
    {
      buf = new StringBuffer();
      writeSixDigitValue(pos+byteCount, buf);
      buf.append("   ");

      lineBytes = Math.min(bytesPerLine, data.length - byteCount);

      for (int i = 0; i < lineBytes ; i++)
      {
        writeByte(data[i+byteCount], buf);
        buf.append(' ');
      }

      // Perform any padding
      if (lineBytes < bytesPerLine)
      {
        for(int i = 0; i < bytesPerLine - lineBytes; i++)
        {
          buf.append("   ");
        }
      }

      buf.append("  ");

      for (int i = 0 ; i < lineBytes; i++)
      {
        char c = (char) data[i+byteCount];
        if (c < ' ' || c > 'z')
        {
          c = '.';
        }
        buf.append(c);
      }

      byteCount+= lineBytes;

      writer.write(buf.toString());
      writer.newLine();
    }

    return cont;
  }

  /**
   * Writes the string passed in as a minimum of four digits
   */
  private void writeSixDigitValue(int pos, StringBuffer buf)
  {
    String val = Integer.toHexString(pos);

    for (int i = 6; i > val.length() ; i--)
    {
      buf.append('0');
    }
    buf.append(val);
  }

  /**
   * Writes the string passed in as a minimum of four digits
   */
  private void writeByte(byte val, StringBuffer buf)
  {    
    String sv = Integer.toHexString((val & 0xff));

    if (sv.length() == 1)
    {
      buf.append('0');
    }
    buf.append(sv);
  }
}

⏎ jxl/demo/BiffDump.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