org.zkoss.zss.range.impl.imexp

Class ExcelXlsxImporter

java.lang.Object

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

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

org.zkoss.zss.range.impl.imexp.ExcelXlsxImporter

All Implemented Interfaces:

SImporter

public class ExcelXlsxImporter
extends AbstractExcelImporter

Specific importing behavior for XLSX.

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
ExcelXlsxImporter()

Method Summary

Methods

Modifier and Type	Method and Description
protected Workbook	createPoiBook(java.io.InputStream is)
protected int	getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet) DefaultBookWidgetLoader.getXSSFHeightInPx()
protected int	getAnchorWidthInPx(ClientAnchor anchor, Sheet poiSheet) Reference DefaultBookWidgetLoader.getXSSFWidthInPx()
protected int	getXoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	getYoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected void	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	importDrawings(Sheet poiSheet, SSheet sheet) Drawings includes charts and pictures.
protected void	importExternalBookLinks() Excel uses external book links to map external book index and name.
protected void	importPassword(Sheet poiSheet, SSheet sheet)
protected void	importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected void	importSheetProtection(Sheet poiSheet, SSheet sheet) POI SheetProtection.
protected void	importTableName(STable table)
protected void	importTables(Sheet poiSheet, SSheet sheet) POI sheet tables
protected void	importValidation(Sheet poiSheet, SSheet sheet) Reference BookHelper.validate()
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, 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

ExcelXlsxImporter

public ExcelXlsxImporter()

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)

[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:

Specified by:

importColumn in class AbstractExcelImporter

importDrawings

protected void importDrawings(Sheet poiSheet,
                  SSheet sheet)

Description copied from class: AbstractExcelImporter

Drawings includes charts and pictures.

Specified by:

importDrawings in class AbstractExcelImporter

getAnchorWidthInPx

protected int getAnchorWidthInPx(ClientAnchor anchor,
                     Sheet poiSheet)

Reference DefaultBookWidgetLoader.getXSSFWidthInPx()

Specified by:

getAnchorWidthInPx in class AbstractExcelImporter

getAnchorHeightInPx

protected int getAnchorHeightInPx(ClientAnchor anchor,
                      Sheet poiSheet)

DefaultBookWidgetLoader.getXSSFHeightInPx()

Specified by:

getAnchorHeightInPx in class AbstractExcelImporter

getXoffsetInPixel

protected int getXoffsetInPixel(ClientAnchor clientAnchor,
                    Sheet poiSheet)

Specified by:

getXoffsetInPixel in class AbstractExcelImporter

getYoffsetInPixel

protected int getYoffsetInPixel(ClientAnchor clientAnchor,
                    Sheet poiSheet)

Specified by:

getYoffsetInPixel in class AbstractExcelImporter

importValidation

protected void importValidation(Sheet poiSheet,
                    SSheet sheet)

Reference BookHelper.validate()

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

importSheetDefaultColumnWidth

protected void importSheetDefaultColumnWidth(Sheet poiSheet,
                                 SSheet sheet)

Overrides:

importSheetDefaultColumnWidth in class AbstractExcelImporter

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

importTableName

protected void importTableName(STable table)