Package | Description |
---|---|
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
Related Documentation
For overviews, tutorials, examples, guides, and tool documentation, please see:
Apache POI Project
|
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 | |
org.zkoss.zss.range.impl.imexp |
ZK Spreadsheet Internal Range API Implementation classes.
|
Modifier and Type | Class and Description |
---|---|
class |
HSSFSheet
High level representation of a worksheet.
|
Modifier and Type | Method and Description |
---|---|
int |
HSSFWorkbook.getSheetIndex(Sheet sheet)
Returns the index of the given 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(java.lang.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(java.lang.String name)
Get sheet with the given name
|
Sheet |
Workbook.getSheetAt(int index)
Get the Sheet object at the given index.
|
Modifier and Type | Method and Description |
---|---|
PivotTable |
PivotTableHelper.createPivotTable(CellReference destination,
java.lang.String name,
PivotCache pivotCache,
Sheet sheet) |
int |
Workbook.getSheetIndex(Sheet sheet)
Returns the index of the given sheet
|
java.util.List<PivotTable> |
PivotTableHelper.initPivotTables(Sheet sheet) |
Modifier and Type | Method and Description |
---|---|
static ChartTextSource |
DataSources.fromCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress) |
static ChartDataSource<java.lang.Number> |
DataSources.fromNumericCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress) |
static ChartDataSource<java.lang.String> |
DataSources.fromStringCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress) |
Modifier and Type | Method and Description |
---|---|
Sheet |
SheetBuilder.build()
Builds sheet from parent workbook and 2D array with cell
values.
|
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
|
Constructor and Description |
---|
CellWalk(Sheet sheet,
CellRangeAddress range) |
Modifier and Type | Class and Description |
---|---|
class |
SXSSFSheet
Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.
|
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(java.lang.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(java.lang.String name)
Get sheet with the given name
|
Sheet |
SXSSFWorkbook.getSheetAt(int index)
Get the Sheet object at the given index.
|
Modifier and Type | Method and Description |
---|---|
int |
SXSSFWorkbook.getSheetIndex(Sheet sheet)
Returns the index of the given 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.
|
Modifier and Type | Method and Description |
---|---|
Sheet |
XSSFPivotTable.getSheet() |
Modifier and Type | Method and Description |
---|---|
int |
XSSFWorkbook.getSheetIndex(Sheet sheet)
Returns the index of the given sheet
|
Modifier and Type | Method and Description |
---|---|
PivotTable |
XSSFPivotTableHelper.createPivotTable(CellReference destination,
java.lang.String name,
PivotCache pivotCache,
Sheet sheet) |
java.util.List<PivotTable> |
XSSFPivotTableHelper.initPivotTables(Sheet sheet) |
Modifier and Type | Method and Description |
---|---|
PivotTable |
PivotTableHelper.createPivotTable(CellReference destination,
java.lang.String name,
PivotCache pivotCache,
Sheet sheet) |
java.util.List<PivotTable> |
PivotTableHelper.initPivotTables(Sheet 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(java.util.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(java.util.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.
|
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(java.util.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) |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.