| java.lang.Object
 org.apache.poi.hssf.dev.HSSF
| HSSF | | public class HSSF (Code) | | 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.
See Also: HSSF.main
author:
Andrew Oliver (acoliver at apache dot org) |
| Constructor Summary | |
| public | HSSF(String filename)
Constructor HSSF - creates an HSSFStream from an InputStream. | | public | HSSF(String filename, boolean write)
Constructor HSSF - given a filename this outputs a sample sheet with just
a set of rows/cells. | | public | HSSF(String infile, String outfile, boolean write)
|
| Method Summary | |
| public static void | main(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. |
| HSSF | | public HSSF(String filename) throws IOException(Code) | | Constructor HSSF - creates an HSSFStream from an InputStream. The HSSFStream
reads in the records allowing modification.
Parameters:
filename -
exception:
IOException - |
| HSSF | | public HSSF(String filename, boolean write) throws IOException(Code) | | Constructor HSSF - given a filename this outputs a sample sheet with just
a set of rows/cells.
Parameters:
filename -
Parameters:
write -
exception:
IOException - |
| HSSF | | public HSSF(String infile, String outfile, boolean write) throws IOException(Code) | | Constructor HSSF - takes in file - attempts to read it then reconstruct it
Parameters:
infile -
Parameters:
outfile -
Parameters:
write -
exception:
IOException - |
| main | | public static void main(String[] args)(Code) | | 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 - |
|
|