org.apache.poi.hssf.dev
Class HSSF

java.lang.Object
  extended by org.apache.poi.hssf.dev.HSSF

public class HSSF
extends java.lang.Object

File for HSSF testing/examples THIS IS NOT THE MAIN HSSF FILE!! This is a util for testing functionality. It does contain sample API usage that may be educational to regular API users.

Author:
Andrew Oliver (acoliver at apache dot org)
See Also:
main(java.lang.String[])

Field Summary
protected  HSSFWorkbook hssfworkbook
           
 
Constructor Summary
HSSF(java.lang.String filename)
          Constructor HSSF - creates an HSSFStream from an InputStream.
HSSF(java.lang.String filename, boolean write)
          Constructor HSSF - given a filename this outputs a sample sheet with just a set of rows/cells.
HSSF(java.lang.String infile, java.lang.String outfile, boolean write)
          Constructor HSSF - takes in file - attempts to read it then reconstruct it
 
Method Summary
static void main(java.lang.String[] args)
          Method main Given 1 argument takes that as the filename, inputs it and dumps the cell values/types out to sys.out given 2 arguments where the second argument is the word "write" and the first is the filename - writes out a sample (test) spreadsheet (see public HSSF(String filename, boolean write)).
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

hssfworkbook

protected HSSFWorkbook hssfworkbook
Constructor Detail

HSSF

public HSSF(java.lang.String filename)
     throws java.io.IOException
Constructor HSSF - creates an HSSFStream from an InputStream. The HSSFStream reads in the records allowing modification.

Parameters:
filename -
Throws:
java.io.IOException

HSSF

public HSSF(java.lang.String filename,
            boolean write)
     throws java.io.IOException
Constructor HSSF - given a filename this outputs a sample sheet with just a set of rows/cells.

Parameters:
filename -
write -
Throws:
java.io.IOException

HSSF

public HSSF(java.lang.String infile,
            java.lang.String outfile,
            boolean write)
     throws java.io.IOException
Constructor HSSF - takes in file - attempts to read it then reconstruct it

Parameters:
infile -
outfile -
write -
Throws:
java.io.IOException
Method Detail

main

public static void main(java.lang.String[] args)
Method main Given 1 argument takes that as the filename, inputs it and dumps the cell values/types out to sys.out given 2 arguments where the second argument is the word "write" and the first is the filename - writes out a sample (test) spreadsheet (see public HSSF(String filename, boolean write)). given 2 arguments where the first is an input filename and the second an output filename (not write), attempts to fully read in the spreadsheet and fully write it out. given 3 arguments where the first is an input filename and the second an output filename (not write) and the third is "modify1", attempts to read in the spreadsheet, deletes rows 0-24, 74-99. Changes cell at row 39, col 3 to "MODIFIED CELL" then writes it out. Hence this is "modify test 1". If you take the output from the write test, you'll have a valid scenario.

Parameters:
args -


Copyright 2008 The Apache Software Foundation or its licensors, as applicable.