public interface ExcelSheetService
| Modifier and Type | Method and Description |
|---|---|
default Row |
createEmptyRow(Sheet sheet)
Creates an empty row in given sheet.
|
Sheet |
createOrGetTypeSheet(Workbook workbook,
java.lang.String typeCode)
Creates a new type sheet in given workbook.
|
Sheet |
createOrGetUtilitySheet(Workbook workbook,
java.lang.String sheetName)
Creates a new utility sheet in given workbook.
|
Sheet |
createTypeSheet(Workbook workbook,
java.lang.String sheetName)
Creates a new sheet and adds it to given workbook.
|
int |
findColumnIndex(Sheet typeSystemSheet,
Sheet sheet,
ExcelAttribute excelAttribute)
Finds column index based on selected attribute.
|
java.lang.String |
findSheetNameForTypeCode(Workbook workbook,
java.lang.String typeCode)
Finds sheet name for given type code.
|
java.lang.String |
findTypeCodeForSheetName(Workbook workbook,
java.lang.String sheetName)
Finds type code for given sheet name.
|
default java.util.Optional<Sheet> |
getSheet(Workbook workbook,
java.lang.String sheetName)
Returns sheet in given workbook
|
java.util.Collection<Sheet> |
getSheets(Workbook workbook)
Returns all sheets except utility sheets.
|
java.util.Collection<java.lang.String> |
getSheetsNames(Workbook workbook)
Returns all sheets names except utility sheets.
|
default Row createEmptyRow(Sheet sheet)
sheet - where the row will be createdSheet createOrGetTypeSheet(Workbook workbook,
java.lang.String typeCode)
workbook - workbook which will be extended by a new sheettypeCode - a new sheet nameSheet createTypeSheet(Workbook workbook,
java.lang.String sheetName)
workbook - workbook which will be extended by a new sheetsheetName - a new sheet nameSheet createOrGetUtilitySheet(Workbook workbook,
java.lang.String sheetName)
workbook - workbook which will be extended by a new sheetsheetName - a new sheet name.java.lang.String findSheetNameForTypeCode(Workbook workbook,
java.lang.String typeCode)
workbook - workbooktypeCode - type codejava.lang.String findTypeCodeForSheetName(Workbook workbook,
java.lang.String sheetName)
workbook - workbooksheetName - sheet nameint findColumnIndex(Sheet typeSystemSheet,
Sheet sheet,
ExcelAttribute excelAttribute)
typeSystemSheet - sheet which contains information about type systemsheet - sheet for current typeexcelAttribute - attribute for which column index should be founddefault java.util.Optional<Sheet> getSheet(Workbook workbook,
java.lang.String sheetName)
workbook - workbooksheetName - name of the looked for sheetjava.util.Collection<Sheet> getSheets(Workbook workbook)
workbook - Workbook object which represents excel filejava.util.Collection<java.lang.String> getSheetsNames(Workbook workbook)
workbook - Workbook object which represents excel fileCopyright © 2018 SAP SE. All Rights Reserved.