Java org.apache.poi.xssf.streaming SXSSFWorkbook fields, constructors, methods, implement or subclass

Example usage for Java org.apache.poi.xssf.streaming SXSSFWorkbook fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.xssf.streaming SXSSFWorkbook.

The text is from its open source code.

Field

int	DEFAULT_WINDOW_SIZE Specifies how many rows can be accessed at most via SXSSFSheet#getRow .

Constructor

	SXSSFWorkbook(XSSFWorkbook workbook) Construct a workbook from a template. There are three use-cases to use SXSSFWorkbook(XSSFWorkbook) : Append new sheets to existing workbooks.
	SXSSFWorkbook(int rowAccessWindowSize) Construct an empty workbook and specify the window for row access.
	SXSSFWorkbook() Construct a new workbook with default row window size
	SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize) Constructs an workbook from an existing workbook.
	SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize, boolean compressTmpFiles, boolean useSharedStringsTable) Constructs an workbook from an existing workbook.
	SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize, boolean compressTmpFiles) Constructs an workbook from an existing workbook.

Method

void	close() Closes the underlying XSSFWorkbook and OPCPackage on which this Workbook is based, if any.
CellStyle	createCellStyle() Create a new Cell style and add it to the workbook's style table
DataFormat	createDataFormat() Returns the instance of DataFormat for this workbook.
Font	createFont() Create a new Font and add it to the workbook's font table
SXSSFSheet	createSheet() Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
SXSSFSheet	createSheet(String sheetname) Create an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
boolean	dispose() Dispose of temporary files backing this workbook on disk.
List	getAllPictures() Gets all pictures from the Workbook.
CellStyle	getCellStyleAt(int idx) Get the cell style object at the given index
CreationHelper	getCreationHelper() Returns an object that handles instantiating concrete classes of the various instances one needs for HSSF, XSSF and SXSSF.
int	getNumberOfSheets() Get the number of spreadsheets in the workbook
SXSSFSheet	getSheet(String name) Get sheet with the given name
SXSSFSheet	getSheetAt(int index) Get the Sheet object at the given index.
String	getSheetName(int sheet) Set the sheet name
XSSFWorkbook	getXSSFWorkbook()
void	setCompressTempFiles(boolean compress) Set whether temp files should be compressed.
void	setSheetName(int sheet, String name) Set the sheet name.
void	setSheetOrder(String sheetname, int pos) Sets the order of appearance for a given sheet.
void	write(OutputStream stream) Write out this workbook to an OutputStream.