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

Introduction

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

The text is from its open source code.

Constructor

	SXSSFSheet(SXSSFWorkbook workbook, XSSFSheet xSheet)

Method

int	addMergedRegion(CellRangeAddress region) Adds a merged region of cells (hence those cells form one)
void	addValidationData(DataValidation dataValidation) Creates a data validation object
void	autoSizeColumn(int column) Adjusts the column width to fit the contents.
SXSSFRow	createRow(int rownum) Create a new row within the sheet and return the high level representation
void	flushRows() Flush all rows to disk.
int	getColumnWidth(int columnIndex) get the width (in units of 1/256th of a character width )
DataValidationHelper	getDataValidationHelper()
int	getFirstRowNum() Gets the first row on the sheet
int	getLastRowNum() Gets the last row on the sheet
CellRangeAddress	getMergedRegion(int index) Returns the merged region at the specified index.
int	getNumMergedRegions() Returns the number of merged regions
PrintSetup	getPrintSetup() Gets the print setup object.
SXSSFRow	getRow(int rownum) Returns the logical row (not physical) 0-based.
SXSSFWorkbook	getWorkbook() Return the parent workbook
void	groupRow(int fromRow, int toRow) Tie a range of rows together so that they can be collapsed or expanded Please note the rows being grouped must be in the current window, if the rows are already flushed then groupRow has no effect.
boolean	isColumnTrackedForAutoSizing(int column) Returns true if column is currently tracked for auto-sizing.
void	setColumnWidth(int columnIndex, int width) Set the width (in units of 1/256th of a character width) The maximum column width for an individual cell is 255 characters.
void	setDisplayGridlines(boolean show) Sets whether the gridlines are shown in a viewer
void	setFitToPage(boolean value) Flag indicating whether the Fit to Page print option is enabled.
void	setHorizontallyCenter(boolean value) Determines whether the output is horizontally centered on the page.
void	setPrintGridlines(boolean show) Turns on or off the printing of gridlines.
void	setRowGroupCollapsed(int row, boolean collapse) Set view state of a grouped range of rows.
void	trackAllColumnsForAutoSizing() Tracks all columns in the sheet for auto-sizing.
void	trackColumnForAutoSizing(int column) Track a column in the sheet for auto-sizing.