org.apache.poi.xssf.streaming

Class SheetDataWriter

java.lang.Object

org.apache.poi.xssf.streaming.SheetDataWriter

Direct Known Subclasses:

GZIPSheetDataWriter

public class SheetDataWriter
extends Object

Initially copied from BigGridDemo "SpreadsheetWriter". Unlike the original code which wrote the entire document, this class only writes the "sheetData" document fragment so that it was renamed to "SheetDataWriter"

Constructor Summary

Constructors

Constructor and Description
SheetDataWriter()

Method Summary

Methods

Modifier and Type	Method and Description
void	close() flush and close the temp data writer.
File	createTempFile() Create a temp file to write sheet data.
Writer	createWriter(File fd) Create a writer for the sheet data.
protected void	finalize()
int	getLastFlushedRow()
int	getLowestIndexOfFlushedRows()
int	getNumberOfCellsOfLastFlushedRow()
int	getNumberOfFlushedRows()
InputStream	getWorksheetXMLInputStream()
protected void	outputQuotedString(String s)
void	writeCell(int columnIndex, Cell cell)
void	writeRow(int rownum, SXSSFRow row) Write a row to the file

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SheetDataWriter

public SheetDataWriter()
                throws IOException

Throws:

IOException

Method Detail

createTempFile

public File createTempFile()
                    throws IOException

Create a temp file to write sheet data. By default, temp files are created in the default temporary-file directory with a prefix "poi-sxssf-sheet" and suffix ".xml". Subclasses can override it and specify a different temp directory or filename or suffix, e.g. .gz

Returns:

temp file to write sheet data

Throws:

IOException

createWriter

public Writer createWriter(File fd)
                    throws IOException

Create a writer for the sheet data.

Parameters:

fd - the file to write to

Throws:

IOException

close

public void close()
           throws IOException

flush and close the temp data writer. This method must be invoked before calling getWorksheetXMLInputStream()

Throws:

IOException

getWorksheetXMLInputStream

public InputStream getWorksheetXMLInputStream()
                                       throws IOException

Returns:

a stream to read temp file with the sheet data

Throws:

IOException

getNumberOfFlushedRows

public int getNumberOfFlushedRows()

getNumberOfCellsOfLastFlushedRow

public int getNumberOfCellsOfLastFlushedRow()

getLowestIndexOfFlushedRows

public int getLowestIndexOfFlushedRows()

getLastFlushedRow

public int getLastFlushedRow()

finalize

protected void finalize()
                 throws Throwable

Overrides:

finalize in class Object

Throws:

Throwable

writeRow

public void writeRow(int rownum,
            SXSSFRow row)
              throws IOException

Write a row to the file

Parameters:

rownum - 0-based row number

row - a row

Throws:

IOException

writeCell

public void writeCell(int columnIndex,
             Cell cell)
               throws IOException

Throws:

IOException

outputQuotedString

protected void outputQuotedString(String s)
                           throws IOException

Throws:

IOException