Package com.hybris.backoffice.excel.template

Class DefaultExcelTemplateService

    • Constructor Detail

      • DefaultExcelTemplateService

        public DefaultExcelTemplateService()
        Deprecated.

    • Method Detail

      • createWorkbook

        public org.apache.poi.ss.usermodel.Workbook createWorkbook​(java.io.InputStream is)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Creates workbook object based on inputStream of excel file. If inputStream doesn't contains excel file then new empty Workbook will be returned.
        Specified by:
        createWorkbook in interface ExcelTemplateService
        Parameters:
        is - Input stream of excel file
        Returns:
        Workbook object which represents excel file

      • getTypeSystemSheet

        public org.apache.poi.ss.usermodel.Sheet getTypeSystemSheet​(org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns sheet which contains metadata about type system
        Specified by:
        getTypeSystemSheet in interface ExcelTemplateService
        Parameters:
        workbook - Workbook object which represents excel file
        Returns:
        Sheet which contains information about type system

      • getSheetsNames

        public java.util.List<java.lang.String> getSheetsNames​(org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns all sheets names except utility sheets.
        Specified by:
        getSheetsNames in interface ExcelTemplateService
        Parameters:
        workbook - Workbook object which represents excel file
        Returns:
        list of sheets names

      • getSheets

        public java.util.List<org.apache.poi.ss.usermodel.Sheet> getSheets​(org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns all sheets except utility sheets.
        Specified by:
        getSheets in interface ExcelTemplateService
        Parameters:
        workbook - Workbook object which represents excel file
        Returns:
        list of sheets

      • getCellValue

        public java.lang.String getCellValue​(org.apache.poi.ss.usermodel.Cell cell)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns cell value as a string value. In case when cell contains formula then the formula is evaluated and result of the evaluation is returned.
        Specified by:
        getCellValue in interface ExcelTemplateService
        Parameters:
        cell - Cell
        Returns:
        string value of cell

      • getHeaders

        public java.util.List<SelectedAttribute> getHeaders​(org.apache.poi.ss.usermodel.Sheet typeSystemSheet,
                                                    org.apache.poi.ss.usermodel.Sheet typeSheet)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns list of selected attributes for given sheet, based on metainformation from type system sheet.
        Specified by:
        getHeaders in interface ExcelTemplateService
        Parameters:
        typeSystemSheet - Sheet contains metainformation about attributes for each type sheets
        typeSheet - Sheet contains data for given sheet
        Returns:
        list of selected attributes

      • getSelectedAttributesQualifiers

        public java.util.List<SelectedAttributeQualifier> getSelectedAttributesQualifiers​(org.apache.poi.ss.usermodel.Sheet typeSystemSheet,
                                                                                  org.apache.poi.ss.usermodel.Sheet typeSheet)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns qualifiers of attributes which at selected in the typSheet
        Specified by:
        getSelectedAttributesQualifiers in interface ExcelTemplateService
        Parameters:
        typeSystemSheet - Sheet contains metainformation about attributes for each type sheets
        typeSheet - Sheet contains data for given sheet
        Returns:
        list of selected attributes.

      • findColumnIndex

        public int findColumnIndex​(org.apache.poi.ss.usermodel.Sheet typeSystemSheet,
                           org.apache.poi.ss.usermodel.Sheet sheet,
                           SelectedAttribute selectedAttribute)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Finds column index based on selected attribute. If column doesn't exist then -1 will be returned.
        Specified by:
        findColumnIndex in interface ExcelTemplateService
        Parameters:
        typeSystemSheet - - sheet which contains information about type system
        sheet - sheet for current type
        selectedAttribute - attribute for which column index should be found.
        Returns:
        column index for given selected attribute. If column doesn't exist then -1 will be returned.

      • createTypeSheet

        public org.apache.poi.ss.usermodel.Sheet createTypeSheet​(java.lang.String typeCode,
                                                         org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Creates a new type sheet in given workbook. If a sheet with given typeCode already exists, it is returned without creating an extra one.
        Specified by:
        createTypeSheet in interface ExcelTemplateService
        Parameters:
        typeCode - a new sheet name
        workbook - workbook which will be extended by a new sheet
        Returns:
        sheet

      • findTypeCodeForSheetName

        public java.lang.String findTypeCodeForSheetName​(java.lang.String sheetName,
                                                 org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Finds type code for given sheet name.
        Specified by:
        findTypeCodeForSheetName in interface ExcelTemplateService
        Parameters:
        sheetName - sheet name.
        workbook - workbook.
        Returns:
        found type code.

      • findSheetNameForTypeCode

        public java.lang.String findSheetNameForTypeCode​(java.lang.String typeCode,
                                                 org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Finds sheet name for given type code.
        Specified by:
        findSheetNameForTypeCode in interface ExcelTemplateService
        Parameters:
        typeCode - type code
        workbook - workbook
        Returns:
        found type code.

      • addTypeSheet

        public void addTypeSheet​(java.lang.String typeName,
                         org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Adds a new sheet to given workbook.
        Specified by:
        addTypeSheet in interface ExcelTemplateService
        Parameters:
        typeName - a new sheet name.
        workbook - workbook which will be extended by a new sheet

      • insertAttributeHeader

        public void insertAttributeHeader​(org.apache.poi.ss.usermodel.Sheet sheet,
                                  SelectedAttribute selectedAttribute,
                                  int columnIndex)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Inserts value to the sheet's header (first row)
        Specified by:
        insertAttributeHeader in interface ExcelTemplateService
        Parameters:
        sheet - where the value will be inserted
        selectedAttribute - a pojo which allows to retrieve value to insert
        columnIndex - index of a column for inserted value

      • insertAttributeValue

        public void insertAttributeValue​(org.apache.poi.ss.usermodel.Cell cell,
                                 java.lang.Object object)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Inserts given value to a given cell
        Specified by:
        insertAttributeValue in interface ExcelTemplateService
        Parameters:
        cell - where the value will be inserted
        object - a value to insert

      • createEmptyRow

        public org.apache.poi.ss.usermodel.Row createEmptyRow​(org.apache.poi.ss.usermodel.Sheet sheet)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Creates an empty row in given sheet.
        Specified by:
        createEmptyRow in interface ExcelTemplateService
        Parameters:
        sheet - where the row will be created
        Returns:
        row

      • getAttributeDisplayName

        public java.lang.String getAttributeDisplayName​(AttributeDescriptorModel attributeDescriptorModel,
                                                java.lang.String isoCode)
        Deprecated.
        Description copied from interface: ExcelTemplateService
        Returns displayed header name based on attribute descriptor
        Specified by:
        getAttributeDisplayName in interface ExcelTemplateService
        Parameters:
        attributeDescriptorModel - attribute descriptor of selected attribute
        isoCode - - isoCode of language
        Returns:
        displayed header name based on attribute descriptor

      • hideUtilitySheet

        @Deprecated
protected void hideUtilitySheet​(org.apache.poi.ss.usermodel.Workbook workbook,
                                java.lang.String sheetName)
        Deprecated.
        since 1808. Process of hiding sheets was moved to HideUtilitySheetsDecorator

      • getUtilitySheetHiddenLevel

        @Deprecated
protected int getUtilitySheetHiddenLevel()
        Deprecated.
        since 1808. Process of hiding sheets was moved to HideUtilitySheetsDecorator

      • activateFirstNonUtilitySheet

        @Deprecated
protected void activateFirstNonUtilitySheet​(org.apache.poi.ss.usermodel.Workbook workbook)
        Deprecated.
        since 1808. Process of hiding sheets was moved to HideUtilitySheetsDecorator

      • setCellService

        public void setCellService​(ExcelCellService cellService)
        Deprecated.

      • setHeaderService

        public void setHeaderService​(ExcelHeaderService headerService)
        Deprecated.

      • setSheetService

        public void setSheetService​(ExcelSheetService sheetService)
        Deprecated.

      • setWorkbookService

        public void setWorkbookService​(ExcelWorkbookService workbookService)
        Deprecated.

      • getTypeService

        public TypeService getTypeService()
        Deprecated.

      • setTypeService

        public void setTypeService​(TypeService typeService)
        Deprecated.

      • getCommonI18NService

        @Deprecated
public CommonI18NService getCommonI18NService()
        Deprecated.
        since 1808.

      • setCommonI18NService

        @Deprecated
public void setCommonI18NService​(CommonI18NService commonI18NService)
        Deprecated.
        since 1808.

      • getExcelTranslatorRegistry

        @Deprecated
public ExcelTranslatorRegistry getExcelTranslatorRegistry()
        Deprecated.
        since 1808.

      • setExcelTranslatorRegistry

        @Deprecated
public void setExcelTranslatorRegistry​(ExcelTranslatorRegistry excelTranslatorRegistry)
        Deprecated.
        since 1808.

      • getPermissionCRUDService

        @Deprecated
public PermissionCRUDService getPermissionCRUDService()
        Deprecated.
        since 1808.

      • setPermissionCRUDService

        @Deprecated
public void setPermissionCRUDService​(PermissionCRUDService permissionCRUDService)
        Deprecated.
        since 1808.

      • getExcelDateUtils

        @Deprecated
public ExcelDateUtils getExcelDateUtils()
        Deprecated.
        since 1808.

      • setExcelDateUtils

        @Deprecated
public void setExcelDateUtils​(ExcelDateUtils excelDateUtils)
        Deprecated.
        since 1808.

      • getExcelSheetNamingStrategy

        @Deprecated
public ExcelSheetNamingStrategy getExcelSheetNamingStrategy()
        Deprecated.
        since 1808.

      • setExcelSheetNamingStrategy

        @Deprecated
public void setExcelSheetNamingStrategy​(ExcelSheetNamingStrategy excelSheetNamingStrategy)
        Deprecated.
        since 1808.