Uses of Interface
org.zkoss.poi.ss.usermodel.Sheet

Packages that use Sheet

Package	Description
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.zkoss.poi.ss.usermodel
org.zkoss.poi.ss.usermodel.charts
org.zkoss.poi.ss.util
org.zkoss.poi.ss.util.cellwalk
org.zkoss.poi.xssf.streaming
org.zkoss.poi.xssf.usermodel
org.zkoss.poi.xssf.usermodel.helpers
org.zkoss.zpoiex.ss.usermodel.helpers

Uses of Sheet in io.keikai.range.impl.imexp

Methods in io.keikai.range.impl.imexp with parameters of type Sheet

Modifier and Type	Method and Description
protected void	ExcelXlsxExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet) See Javadoc at AbstractExcelImporter importAutoFilter().
protected void	ExcelXlsExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportChart(SSheet sheet, Sheet poiSheet) reference DrawingManagerImpl.addChartX()
protected void	ExcelXlsExporter.exportChart(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportChart(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void	ExcelXlsExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected abstract void	AbstractExcelExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void	ExcelXlsxExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportMergedRegions(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportPassword(SSheet sheet, Sheet poiSheet) Export hashed password directly to poiSheet.
protected void	ExcelXlsExporter.exportPassword(SSheet sheet, Sheet poiSheet) Export hashed password directly to poiSheet.
protected abstract void	AbstractExcelExporter.exportPassword(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportPicture(SSheet sheet, Sheet poiSheet) Reference DrawingManagerImpl.addPicture()
protected void	ExcelXlsExporter.exportPicture(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportPicture(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportRow(SSheet sheet, Sheet poiSheet, SRow row)
protected void	AbstractExcelExporter.exportRowColumn(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportSheetProtection(SSheet sheet, Sheet poiSheet) POI SheetProtection.
protected int	ExcelXlsxExporter.exportTables(SSheet sheet, Sheet poiSheet0, int tbId)
protected int	ExcelXlsExporter.exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected abstract int	AbstractExcelExporter.exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected void	ExcelXlsxExporter.exportValidation(SSheet sheet, Sheet poiSheet) According to SDataValidation.ValidationType, FORMULA means custom validation.
protected void	ExcelXlsExporter.exportValidation(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportValidation(SSheet sheet, Sheet poiSheet)
protected int	ExcelXlsxImporter.getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet) DefaultBookWidgetLoader.getXSSFHeightInPx()
protected int	ExcelXlsImporter.getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet) reference DefaultBookWidgetLoader.getHSSFHeightInPx()
protected abstract int	AbstractExcelImporter.getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet)
protected int	ExcelXlsxImporter.getAnchorWidthInPx(ClientAnchor anchor, Sheet poiSheet) Reference DefaultBookWidgetLoader.getXSSFWidthInPx()
protected int	ExcelXlsImporter.getAnchorWidthInPx(ClientAnchor anchor, Sheet sheet) reference DefaultBookWidgetLoader.getHSSFWidthInPx()
protected abstract int	AbstractExcelImporter.getAnchorWidthInPx(ClientAnchor anchor, Sheet poiSheet) If in same column: anchorWidthInFirstColumn + anchor width in inter-columns + anchorWidthInLastColumn (dx2) no in same column: anchorWidthInLastColumn - offsetInFirstColumn (dx1)
static int	BookHelper.getColumnFreeze(Sheet sheet) gets the column freeze, 1 base
static int	ImExpUtils.getHeightAny(Sheet poiSheet, int row)
protected int	ExcelXlsImporter.getLastChangedColumnIndex(Sheet poiSheet)
static int	BookHelper.getRowFreeze(Sheet sheet) gets the row freeze, 1 base
static int	ImExpUtils.getRowHeightInPx(Sheet poiSheet, Row row)
static int	ImExpUtils.getWidthAny(Sheet poiSheet, int col, int charWidth)
protected int	ExcelXlsxImporter.getXoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	ExcelXlsImporter.getXoffsetInPixel(ClientAnchor anchor, Sheet poiSheet)
protected abstract int	AbstractExcelImporter.getXoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	ExcelXlsxImporter.getYoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	ExcelXlsImporter.getYoffsetInPixel(ClientAnchor anchor, Sheet poiSheet)
protected abstract int	AbstractExcelImporter.getYoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected void	AbstractExcelImporter.importAutoFilter(Sheet poiSheet, SSheet sheet) POI AutoFilter.getFilterColumn(i) sometimes returns null.
protected void	ExcelXlsxImporter.importChart(List<ZssChartX> poiCharts, Sheet poiSheet, SSheet sheet) Not import X & Y axis title because XSSFCategoryAxis doesn't provide API to get title.
protected void	ExcelXlsImporter.importChart(List<ZssChartX> poiCharts, Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxImporter.importColumn(Sheet poiSheet, SSheet sheet) [ISO/IEC 29500-1 1st Edition] 18.3.1.13 col (Column Width & Formatting) By experiments, CT_Col is always created in ascending order by min and the range specified by min & max doesn't overlap each other. For example:
protected void	ExcelXlsImporter.importColumn(Sheet poiSheet, SSheet sheet) When a column is hidden with default width, we don't import the width for it's 0.
protected abstract void	AbstractExcelImporter.importColumn(Sheet poiSheet, SSheet sheet) When a column is hidden with default width, we don't import the width for it's 0.
protected void	ExcelXlsxImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxImporter.importDrawings(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importDrawings(Sheet poiSheet, SSheet sheet) reference DrawingManagerImpl.initHSSFDrawings()
protected abstract void	AbstractExcelImporter.importDrawings(Sheet poiSheet, SSheet sheet) Drawings includes charts and pictures.
protected void	AbstractExcelImporter.importMergedRegions(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected void	AbstractExcelImporter.importPicture(List<Picture> poiPictures, Sheet poiSheet, SSheet sheet)
protected SSheet	AbstractExcelImporter.importSheet(Sheet poiSheet, int poiSheetIndex)
protected void	ExcelXlsxImporter.importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected void	AbstractExcelImporter.importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxImporter.importSheetProtection(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importSheetProtection(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importSheetProtection(Sheet poiSheet, SSheet sheet) POI SheetProtection.
protected void	ExcelXlsxImporter.importTables(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importTables(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importTables(Sheet poiSheet, SSheet sheet) POI sheet tables
protected void	ExcelXlsxImporter.importValidation(Sheet poiSheet, SSheet sheet) Reference BookHelper.validate()
protected void	ExcelXlsImporter.importValidation(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importValidation(Sheet poiSheet, SSheet sheet)
static boolean	BookHelper.isFreezePane(Sheet sheet)
protected void	ExcelXlsxExporter.plotPoiChart(SChart chart, ChartData chartData, SSheet sheet, Sheet poiSheet) Create and plot a POI chart with its chart data.
protected ViewAnchor	AbstractExcelImporter.toViewAnchor(Sheet poiSheet, ClientAnchor clientAnchor)

Uses of Sheet in org.zkoss.poi.hssf.usermodel

Classes in org.zkoss.poi.hssf.usermodel that implement Sheet

Modifier and Type	Class and Description
class	HSSFSheet High level representation of a worksheet.

Methods in org.zkoss.poi.hssf.usermodel with parameters of type Sheet

Modifier and Type	Method and Description
int	HSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

Uses of Sheet in org.zkoss.poi.ss.usermodel

Methods in org.zkoss.poi.ss.usermodel that return Sheet

Modifier and Type	Method and Description
Sheet	Workbook.cloneSheet(int sheetNum) Create an Sheet from an existing sheet in the Workbook.
Sheet	Workbook.createSheet() Create a Sheet for this Workbook, adds it to the sheets and returns the high level representation.
Sheet	Workbook.createSheet(String sheetname) Create a new sheet for this Workbook and return the high level representation.
Sheet	Row.getSheet() Returns the Sheet this row belongs to
Sheet	Cell.getSheet() Returns the sheet this cell belongs to
Sheet	Workbook.getSheet(String name) Get sheet with the given name
Sheet	Workbook.getSheetAt(int index) Get the Sheet object at the given index.

Methods in org.zkoss.poi.ss.usermodel with parameters of type Sheet

Modifier and Type	Method and Description
PivotTable	PivotTableHelper.createPivotTable(CellReference destination, String name, PivotCache pivotCache, Sheet sheet)
int	Workbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet
List<PivotTable>	PivotTableHelper.initPivotTables(Sheet sheet)

Uses of Sheet in org.zkoss.poi.ss.usermodel.charts

Methods in org.zkoss.poi.ss.usermodel.charts with parameters of type Sheet

Modifier and Type	Method and Description
static ChartTextSource	DataSources.fromCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)
static ChartDataSource<Number>	DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)
static ChartDataSource<String>	DataSources.fromStringCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)

Uses of Sheet in org.zkoss.poi.ss.util

Methods in org.zkoss.poi.ss.util that return Sheet

Modifier and Type	Method and Description
Sheet	SheetBuilder.build() Builds sheet from parent workbook and 2D array with cell values.

Methods in org.zkoss.poi.ss.util with parameters of type Sheet

Modifier and Type	Method and Description
static double	SheetUtil.getColumnWidth(Sheet sheet, int column, boolean useMergedCells) Compute width of a column and return the result
static double	SheetUtil.getColumnWidth(Sheet sheet, int column, boolean useMergedCells, int firstRow, int lastRow) Compute width of a column based on a subset of the rows and return the result
static Row	CellUtil.getRow(int rowIndex, Sheet sheet) Get a row from the spreadsheet, and create it if it doesn't exist.
static void	RegionUtil.setBorderBottom(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the borderBottom attribute of the RegionUtil object
static void	RegionUtil.setBorderLeft(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
static void	RegionUtil.setBorderRight(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the borderRight attribute of the RegionUtil object
static void	RegionUtil.setBorderTop(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the borderBottom attribute of the RegionUtil object
static void	RegionUtil.setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the bottomBorderColor attribute of the RegionUtil object
static void	RegionUtil.setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the leftBorderColor attribute of the RegionUtil object
static void	RegionUtil.setRightBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the rightBorderColor attribute of the RegionUtil object
static void	RegionUtil.setTopBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the topBorderColor attribute of the RegionUtil object

Uses of Sheet in org.zkoss.poi.ss.util.cellwalk

Constructors in org.zkoss.poi.ss.util.cellwalk with parameters of type Sheet

Constructor and Description
CellWalk(Sheet sheet, CellRangeAddress range)

Uses of Sheet in org.zkoss.poi.xssf.streaming

Classes in org.zkoss.poi.xssf.streaming that implement Sheet

Modifier and Type	Class and Description
class	SXSSFSheet Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.

Methods in org.zkoss.poi.xssf.streaming that return Sheet

Modifier and Type	Method and Description
Sheet	SXSSFWorkbook.cloneSheet(int sheetNum) Create an Sheet from an existing sheet in the Workbook.
Sheet	SXSSFWorkbook.createSheet() Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
Sheet	SXSSFWorkbook.createSheet(String sheetname) Create an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
Sheet	SXSSFRow.getSheet() Returns the Sheet this row belongs to
Sheet	SXSSFCell.getSheet() Returns the sheet this cell belongs to
Sheet	SXSSFWorkbook.getSheet(String name) Get sheet with the given name
Sheet	SXSSFWorkbook.getSheetAt(int index) Get the Sheet object at the given index.

Methods in org.zkoss.poi.xssf.streaming with parameters of type Sheet

Modifier and Type	Method and Description
int	SXSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

Uses of Sheet in org.zkoss.poi.xssf.usermodel

Classes in org.zkoss.poi.xssf.usermodel that implement Sheet

Modifier and Type	Class and Description
class	XSSFChartSheet High level representation of Sheet Parts that are of type 'chartsheet'.
class	XSSFDialogsheet
class	XSSFSheet High level representation of a SpreadsheetML worksheet.

Methods in org.zkoss.poi.xssf.usermodel that return Sheet

Modifier and Type	Method and Description
Sheet	XSSFPivotTable.getSheet()

Methods in org.zkoss.poi.xssf.usermodel with parameters of type Sheet

Modifier and Type	Method and Description
int	XSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

Uses of Sheet in org.zkoss.poi.xssf.usermodel.helpers

Methods in org.zkoss.poi.xssf.usermodel.helpers with parameters of type Sheet

Modifier and Type	Method and Description
PivotTable	XSSFPivotTableHelper.createPivotTable(CellReference destination, String name, PivotCache pivotCache, Sheet sheet)
List<PivotTable>	XSSFPivotTableHelper.initPivotTables(Sheet sheet)

Uses of Sheet in org.zkoss.zpoiex.ss.usermodel.helpers

Methods in org.zkoss.zpoiex.ss.usermodel.helpers with parameters of type Sheet

Modifier and Type	Method and Description
PivotTable	PivotTableHelper.createPivotTable(CellReference destination, String name, PivotCache pivotCache, Sheet sheet)
List<PivotTable>	PivotTableHelper.initPivotTables(Sheet sheet)