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.xssf.usermodel | |
org.zkoss.zss.range.impl.imexp |
ZK Spreadsheet Internal Range API Implementation classes.
|
Modifier and Type | Class and Description |
---|---|
class |
HSSFClientAnchor
A client anchor is attached to an excel worksheet.
|
Modifier and Type | Method and Description |
---|---|
ClientAnchor |
HSSFPicture.getClientAnchor() |
ClientAnchor |
HSSFCombo.getClientAnchor() |
ClientAnchor |
HSSFChartShape.getPreferredSize() |
Modifier and Type | Method and Description |
---|---|
HSSFComment |
HSSFPatriarch.createCellComment(ClientAnchor anchor) |
Chart |
HSSFPatriarch.createChart(ClientAnchor anchor) |
HSSFPicture |
HSSFPatriarch.createPicture(ClientAnchor anchor,
int pictureIndex) |
void |
HSSFPatriarch.moveChart(ZssChartX chart,
ClientAnchor anchor) |
void |
HSSFPatriarch.movePicture(Picture pic,
ClientAnchor anchor) |
void |
HSSFPicture.setClientAnchor(ClientAnchor newanchor) |
void |
HSSFChartShape.setClientAnchor(ClientAnchor newanchor) |
Modifier and Type | Method and Description |
---|---|
ClientAnchor |
Drawing.createAnchor(int dx1,
int dy1,
int dx2,
int dy2,
int col1,
int row1,
int col2,
int row2)
Creates a new client anchor and sets the top-left and bottom-right
coordinates of the anchor.
|
ClientAnchor |
CreationHelper.createClientAnchor() |
ClientAnchor |
Picture.getClientAnchor() |
ClientAnchor |
Combo.getClientAnchor() |
ClientAnchor |
ZssChartX.getPreferredSize() |
ClientAnchor |
Picture.getPreferredSize() |
ClientAnchor |
Chart.getPreferredSize() |
Modifier and Type | Method and Description |
---|---|
Comment |
Drawing.createCellComment(ClientAnchor anchor)
Creates a comment.
|
Chart |
Drawing.createChart(ClientAnchor anchor)
Creates a chart.
|
Picture |
Drawing.createPicture(ClientAnchor anchor,
int pictureIndex)
Creates a picture.
|
void |
Drawing.moveChart(ZssChartX chart,
ClientAnchor anchor) |
void |
Drawing.movePicture(Picture pic,
ClientAnchor anchor) |
void |
ZssChartX.setClientAnchor(ClientAnchor anchor) |
void |
Picture.setClientAnchor(ClientAnchor anchor) |
void |
Chart.setClientAnchor(ClientAnchor anchor) |
Modifier and Type | Class and Description |
---|---|
class |
XSSFClientAnchor
A client anchor is attached to an excel worksheet.
|
Modifier and Type | Method and Description |
---|---|
ClientAnchor |
XSSFPicture.getClientAnchor() |
ClientAnchor |
XSSFCombo.getClientAnchor() |
ClientAnchor |
XSSFChartX.getPreferredSize() |
ClientAnchor |
XSSFChart.getPreferredSize() |
Modifier and Type | Method and Description |
---|---|
XSSFComment |
XSSFDrawing.createCellComment(ClientAnchor anchor)
Creates a comment.
|
XSSFChart |
XSSFDrawing.createChart(ClientAnchor anchor) |
XSSFPicture |
XSSFDrawing.createPicture(ClientAnchor anchor,
int pictureIndex) |
void |
XSSFDrawing.moveChart(ZssChartX chartX,
ClientAnchor anchor) |
void |
XSSFDrawing.movePicture(Picture pic,
ClientAnchor anchor) |
void |
XSSFPicture.setClientAnchor(ClientAnchor newanchor) |
void |
XSSFChartX.setClientAnchor(ClientAnchor newanchor) |
void |
XSSFChart.setClientAnchor(ClientAnchor newanchor) |
Modifier and Type | Method and Description |
---|---|
protected ClientAnchor |
ExcelXlsxExporter.toClientAnchor(ViewAnchor viewAnchor,
SSheet sheet) |
Modifier and Type | Method and Description |
---|---|
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)
|
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 ViewAnchor |
AbstractExcelImporter.toViewAnchor(Sheet poiSheet,
ClientAnchor clientAnchor) |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.