org.zkoss.zss.range.impl.imexp

Class ExcelXlsImporter

java.lang.Object

org.zkoss.zss.range.impl.imexp.AbstractImporter

org.zkoss.zss.range.impl.imexp.AbstractExcelImporter

org.zkoss.zss.range.impl.imexp.ExcelXlsImporter

All Implemented Interfaces:

SImporter

public class ExcelXlsImporter
extends AbstractExcelImporter

Since:

3.5.0

Author:

Hawk

Field Summary

Fields inherited from class org.zkoss.zss.range.impl.imexp.AbstractExcelImporter

book, BOOK_TYPE_KEY, CHRACTER_WIDTH, importedFont, importedPictureData, importedStyle, workbook

Constructor Summary

Constructors

Constructor and Description
ExcelXlsImporter()

Method Summary

Modifier and Type	Method and Description
protected Workbook	createPoiBook(java.io.InputStream is)
protected int	getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet) reference DefaultBookWidgetLoader.getHSSFHeightInPx()
protected int	getAnchorWidthInPx(ClientAnchor anchor, Sheet sheet) reference DefaultBookWidgetLoader.getHSSFWidthInPx()
protected int	getXoffsetInPixel(ClientAnchor anchor, Sheet poiSheet)
protected int	getYoffsetInPixel(ClientAnchor anchor, Sheet poiSheet)
protected void	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	importDrawings(Sheet poiSheet, SSheet sheet) reference DrawingManagerImpl.initHSSFDrawings()
protected void	importExternalBookLinks() Excel uses external book links to map external book index and name.
protected void	importPassword(Sheet poiSheet, SSheet sheet)
protected void	importSheetProtection(Sheet poiSheet, SSheet sheet) POI SheetProtection.
protected void	importTables(Sheet poiSheet, SSheet sheet) POI sheet tables
protected void	importValidation(Sheet poiSheet, SSheet sheet)
protected void	setBookType(SBook book)
protected boolean	skipName(Name definedName)

Methods inherited from class org.zkoss.zss.range.impl.imexp.AbstractExcelImporter

createZssFont, getBookType, importAutoFilterColumns, importCell, importCellStyle, importCellStyle, importFont, importMergedRegions, importNamedRange, importPicture, importRichText, importRow, imports, importSheet, importSheetDefaultColumnWidth, isImportCache, setImportCache, toViewAnchor, toZssFont

Methods inherited from class org.zkoss.zss.range.impl.imexp.AbstractImporter

imports, imports

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelXlsImporter

public ExcelXlsImporter()

Method Detail

createPoiBook

protected Workbook createPoiBook(java.io.InputStream is)
                          throws java.io.IOException

Specified by:

createPoiBook in class AbstractExcelImporter

Throws:

java.io.IOException

importExternalBookLinks

protected void importExternalBookLinks()

Description copied from class: AbstractExcelImporter

Excel uses external book links to map external book index and name. The formula contains full external book name or index only (e.g [book2.xlsx] or [1]). We needs such table for parsing and evaluating formula when necessary.

Specified by:

importExternalBookLinks in class AbstractExcelImporter

importColumn

protected void importColumn(Sheet poiSheet,
                            SSheet sheet)

When a column is hidden with default width, we don't import the width for it's 0. We also don't import the width that equals to default width for optimization.

Specified by:

importColumn in class AbstractExcelImporter

importDrawings

protected void importDrawings(Sheet poiSheet,
                              SSheet sheet)

reference DrawingManagerImpl.initHSSFDrawings()

Specified by:

importDrawings in class AbstractExcelImporter

Parameters:

poiSheet -

getAnchorHeightInPx

protected int getAnchorHeightInPx(ClientAnchor anchor,
                                  Sheet poiSheet)

reference DefaultBookWidgetLoader.getHSSFHeightInPx()

Specified by:

getAnchorHeightInPx in class AbstractExcelImporter

Parameters:

anchor -

poiSheet -

Returns:

getAnchorWidthInPx

protected int getAnchorWidthInPx(ClientAnchor anchor,
                                 Sheet sheet)

reference DefaultBookWidgetLoader.getHSSFWidthInPx()

Specified by:

getAnchorWidthInPx in class AbstractExcelImporter

Parameters:

anchor -

sheet -

Returns:

getXoffsetInPixel

protected int getXoffsetInPixel(ClientAnchor anchor,
                                Sheet poiSheet)

Specified by:

getXoffsetInPixel in class AbstractExcelImporter

getYoffsetInPixel

protected int getYoffsetInPixel(ClientAnchor anchor,
                                Sheet poiSheet)

Specified by:

getYoffsetInPixel in class AbstractExcelImporter

importValidation

protected void importValidation(Sheet poiSheet,
                                SSheet sheet)

Specified by:

importValidation in class AbstractExcelImporter

skipName

protected boolean skipName(Name definedName)

Overrides:

skipName in class AbstractExcelImporter

setBookType

protected void setBookType(SBook book)

Specified by:

setBookType in class AbstractExcelImporter

importPassword

protected void importPassword(Sheet poiSheet,
                              SSheet sheet)

Specified by:

importPassword in class AbstractExcelImporter

importSheetProtection

protected void importSheetProtection(Sheet poiSheet,
                                     SSheet sheet)

Description copied from class: AbstractExcelImporter

POI SheetProtection.

Specified by:

importSheetProtection in class AbstractExcelImporter

Parameters:

poiSheet - source POI sheet

sheet - destination sheet

importTables

protected void importTables(Sheet poiSheet,
                            SSheet sheet)

Description copied from class: AbstractExcelImporter

POI sheet tables

Specified by:

importTables in class AbstractExcelImporter

Parameters:

poiSheet - source POI sheet

sheet - destination sheet