io.keikai.range.impl.imexp

Class ExcelXlsxImporter

java.lang.Object

io.keikai.range.impl.imexp.AbstractImporter

io.keikai.range.impl.imexp.AbstractExcelImporter

io.keikai.range.impl.imexp.ExcelXlsxImporter

All Implemented Interfaces:

SImporter, Serializable

public class ExcelXlsxImporter
extends AbstractExcelImporter

Specific importing behavior for XLSX.

Since:

3.5.0

Author:

Hawk

See Also:

Serialized Form

Field Summary

Fields inherited from class io.keikai.range.impl.imexp.AbstractExcelImporter

_importCache, book, BOOK_TYPE_KEY, importedFont, importedPictureData, importedStyle, workbook

Constructor Summary

Constructors

Constructor and Description
ExcelXlsxImporter()

Method Summary

Modifier and Type	Method and Description
protected SFont	createDxfZssFont(Font poiFont)
protected Workbook	createPoiBook(InputStream is)
protected XSSFChartX	createXSSFChartX(XSSFDrawing patriarch, org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTGraphicalObjectFrame gfrm, XSSFClientAnchor xanchor)
protected int	getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet) DefaultBookWidgetLoader.getXSSFHeightInPx()
protected int	getAnchorWidthInPx(ClientAnchor anchor, Sheet poiSheet) Reference DefaultBookWidgetLoader.getXSSFWidthInPx()
protected String	getTitleFormula(ChartTextSource textSource, int seriesIndex) return a formula or generate a default title ("Series[N]")if title doesn't exist.
protected String	getValueFormula(ChartDataSource<?> dataSource) reference ChartHelper.prepareValues()
protected int	getXoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	getYoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected void	importAxis(XSSFChart xssfChart, SChart chart)
protected SBorder	importBorder(DxfCellStyle poiCellStyle)
protected void	importChart(List<ZssChartX> poiCharts, Sheet poiSheet, SSheet sheet) Not import X & Y axis title because XSSFCategoryAxis doesn't provide API to get title.
protected SColorFilter	importColorFilter(ColorFilter colorFilter)
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:
protected void	importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected SCustomFilters	importCustomFilters(CustomFilters poiCustomFilters)
protected void	importDrawings(Sheet poiSheet, SSheet sheet) Drawings includes charts and pictures.
protected SDynamicFilter	importDynamicFilter(DynamicFilter poiDynamicFilter)
protected void	importExternalBookLinks() Excel uses external book links to map external book index and name.
protected SExtraStyle	importExtraStyle(DxfCellStyle poiCellStyle)
protected void	importExtraStyles()
protected SFont	importFont(CellStyle poiCellStyle)
protected void	importPassword(Sheet poiSheet, SSheet sheet)
protected void	importSeries(List<? extends CategoryDataSerie> seriesList, SGeneralChartData chartData) reference ChartHepler.prepareCategoryModel() Category normally indicates the values show on X axis.
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 STableStyle	importTableStyle(TableStyle poiTableStyle)
protected STableStyleElem	importTableStyleElem(TableStyle poiTableStyle, String name)
protected void	importTableStyles()
protected STop10Filter	importTop10Filter(Top10Filter poiTop10Filter)
protected void	importValidation(Sheet poiSheet, SSheet sheet) Reference BookHelper.validate()
protected void	importXySeries(List<? extends XYDataSerie> seriesList, SGeneralChartData chartData)
protected void	importXyzSeries(List<? extends XYZDataSerie> seriesList, SGeneralChartData chartData) reference ChartHepler.prepareXYZModel()
protected SColorScale	prepareColorScale(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)
protected ConditionalFormattingImpl	prepareConditionalFormattingImpl(SSheet sheet, XSSFConditionalFormatting cf)
protected ConditionalFormattingRuleImpl	prepareConditonalFormattingRuleImpl(SConditionalFormatting cfi, XSSFConditionalFormattingRule poiRule)
protected SDataBar	prepareDataBar(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)
protected void	prepareFormulas(ConditionalFormattingRuleImpl cfri, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)
protected SIconSet	prepareIconSet(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)
protected SCFValueObject	prepareValueObject(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo ctvo)
protected void	setBookType(SBook book)
protected boolean	skipName(Name definedName)
protected SConditionalFormattingRule.RuleOperator	toCFRuleOperator(org.openxmlformats.schemas.spreadsheetml.x2006.main.STConditionalFormattingOperator.Enum ctType)
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfType.Enum	toConditionalFormatingRuleType(SConditionalFormattingRule.RuleType stype)
protected SConditionalFormattingRule.RuleType	toConditionalFormattingRuleType(org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfType.Enum cfType)
protected SIconSet.IconSetType	toIconSetType(org.openxmlformats.schemas.spreadsheetml.x2006.main.STIconSetType.Enum ctType)
protected SConditionalFormattingRule.RuleTimePeriod	toTimePeriod(org.openxmlformats.schemas.spreadsheetml.x2006.main.STTimePeriod.Enum ctPeriod)
protected SCFValueObject.CFValueObjectType	toValueObjectType(org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfvoType.Enum ctType)

Methods inherited from class io.keikai.range.impl.imexp.AbstractExcelImporter

createZssFont, getBookType, getPoiFontFromRichText, importAutoFilter, importAutoFilterColumns, importCell, importCellStyle, importCellStyle, importDefaultCellStyles, importMergedRegions, importNamedRange, importNamedStyles, importPicture, importRichText, importRow, imports, importSheet, isImportCache, mustCalc, setImportCache, toViewAnchor, toZssFont

Methods inherited from class io.keikai.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(InputStream is)
                          throws IOException

Specified by:

createPoiBook in class AbstractExcelImporter

Throws:

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

importChart

protected void importChart(List<ZssChartX> poiCharts,
                           Sheet poiSheet,
                           SSheet sheet)

Not import X & Y axis title because XSSFCategoryAxis doesn't provide API to get title. Reference ChartHelper.drawXSSFChart()

importAxis

protected void importAxis(XSSFChart xssfChart,
                          SChart chart)

importSeries

protected void importSeries(List<? extends CategoryDataSerie> seriesList,
                            SGeneralChartData chartData)

reference ChartHepler.prepareCategoryModel() Category normally indicates the values show on X axis. Tile indicates the name for each series.

Parameters:

seriesList - source chart data

chartData - destination chart data

importXySeries

protected void importXySeries(List<? extends XYDataSerie> seriesList,
                              SGeneralChartData chartData)

importXyzSeries

protected void importXyzSeries(List<? extends XYZDataSerie> seriesList,
                               SGeneralChartData chartData)

reference ChartHepler.prepareXYZModel()

Parameters:

seriesList -

chart -

getTitleFormula

protected String getTitleFormula(ChartTextSource textSource,
                                 int seriesIndex)

return a formula or generate a default title ("Series[N]")if title doesn't exist. reference ChartHelper.prepareTitle()

Parameters:

textSource -

Returns:

getValueFormula

protected String getValueFormula(ChartDataSource<?> dataSource)

reference ChartHelper.prepareValues()

Parameters:

dataSource -

Returns:

importDrawings

protected void importDrawings(Sheet poiSheet,
                              SSheet sheet)

Description copied from class: AbstractExcelImporter

Drawings includes charts and pictures.

Specified by:

importDrawings in class AbstractExcelImporter

createXSSFChartX

protected XSSFChartX createXSSFChartX(XSSFDrawing patriarch,
                                      org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTGraphicalObjectFrame gfrm,
                                      XSSFClientAnchor xanchor)

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)

importExtraStyles

protected void importExtraStyles()

Overrides:

importExtraStyles in class AbstractExcelImporter

importExtraStyle

protected SExtraStyle importExtraStyle(DxfCellStyle poiCellStyle)

importBorder

protected SBorder importBorder(DxfCellStyle poiCellStyle)

createDxfZssFont

protected SFont createDxfZssFont(Font poiFont)

importFont

protected SFont importFont(CellStyle poiCellStyle)

Overrides:

importFont in class AbstractExcelImporter

importConditionalFormatting

protected void importConditionalFormatting(SSheet sheet,
                                           Sheet poiSheet)

Specified by:

importConditionalFormatting in class AbstractExcelImporter

prepareConditionalFormattingImpl

protected ConditionalFormattingImpl prepareConditionalFormattingImpl(SSheet sheet,
                                                                     XSSFConditionalFormatting cf)

prepareConditonalFormattingRuleImpl

protected ConditionalFormattingRuleImpl prepareConditonalFormattingRuleImpl(SConditionalFormatting cfi,
                                                                            XSSFConditionalFormattingRule poiRule)

prepareIconSet

protected SIconSet prepareIconSet(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)

prepareColorScale

protected SColorScale prepareColorScale(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)

prepareDataBar

protected SDataBar prepareDataBar(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)

prepareFormulas

protected void prepareFormulas(ConditionalFormattingRuleImpl cfri,
                               org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule)

prepareValueObject

protected SCFValueObject prepareValueObject(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo ctvo)

toTimePeriod

protected SConditionalFormattingRule.RuleTimePeriod toTimePeriod(org.openxmlformats.schemas.spreadsheetml.x2006.main.STTimePeriod.Enum ctPeriod)

toCFRuleOperator

protected SConditionalFormattingRule.RuleOperator toCFRuleOperator(org.openxmlformats.schemas.spreadsheetml.x2006.main.STConditionalFormattingOperator.Enum ctType)

toIconSetType

protected SIconSet.IconSetType toIconSetType(org.openxmlformats.schemas.spreadsheetml.x2006.main.STIconSetType.Enum ctType)

toValueObjectType

protected SCFValueObject.CFValueObjectType toValueObjectType(org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfvoType.Enum ctType)

toConditionalFormattingRuleType

protected SConditionalFormattingRule.RuleType toConditionalFormattingRuleType(org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfType.Enum cfType)

toConditionalFormatingRuleType

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfType.Enum toConditionalFormatingRuleType(SConditionalFormattingRule.RuleType stype)

importTableStyles

protected void importTableStyles()

Overrides:

importTableStyles in class AbstractExcelImporter

importTableStyleElem

protected STableStyleElem importTableStyleElem(TableStyle poiTableStyle,
                                               String name)

importTableStyle

protected STableStyle importTableStyle(TableStyle poiTableStyle)

importColorFilter

protected SColorFilter importColorFilter(ColorFilter colorFilter)

Specified by:

importColorFilter in class AbstractExcelImporter

importCustomFilters

protected SCustomFilters importCustomFilters(CustomFilters poiCustomFilters)

Specified by:

importCustomFilters in class AbstractExcelImporter

importDynamicFilter

protected SDynamicFilter importDynamicFilter(DynamicFilter poiDynamicFilter)

Specified by:

importDynamicFilter in class AbstractExcelImporter

importTop10Filter

protected STop10Filter importTop10Filter(Top10Filter poiTop10Filter)

Specified by:

importTop10Filter in class AbstractExcelImporter