Package org.eclipse.epsilon.emc.spreadsheets.excel

Class ExcelWorksheet

java.lang.Object

org.eclipse.epsilon.emc.spreadsheets.SpreadsheetWorksheet

org.eclipse.epsilon.emc.spreadsheets.excel.ExcelWorksheet

public class ExcelWorksheet
extends SpreadsheetWorksheet

Field Summary

Fields

Modifier and Type	Field	Description
protected ExcelModel	model
protected org.apache.poi.ss.usermodel.Sheet	sheet

Fields inherited from class org.eclipse.epsilon.emc.spreadsheets.SpreadsheetWorksheet

alias, dataTypeStrict, existsInSpreadsheet, header, name

Constructor Summary

Constructors

Constructor	Description
ExcelWorksheet(ExcelModel model, org.apache.poi.ss.usermodel.Sheet sheet, boolean existsInSpreadsheet)

Method Summary

Modifier and Type	Method	Description
protected SpreadsheetColumn	createColumn(int index)	Creates a column with the specified column index
protected void	createInSpreadsheet()	The purpose of this method is to create this worksheet in the spreadsheet
String	getDefaultEmptyCellValue()	This method returns the default value to be written to a cell when a new empty row is created in a worksheet that is not enforcing data type strictness.
int	getFirstRowIndex()
int	getHeaderRowIndex()
List<SpreadsheetRow>	getRows()	Gets all rows contained by the worksheet
SpreadsheetRow	insertRow(Map<SpreadsheetColumn,String> values)	Inserts a new row in the worksheet with given values in the given columns.
protected void	loadHeader()	Loads header row information - index and name - from the spreadsheet if the worksheet exists in the spreadsheet
void	removeRow(SpreadsheetRow row)	Deletes the given row from the actual worksheet.

Methods inherited from class org.eclipse.epsilon.emc.spreadsheets.SpreadsheetWorksheet

addColumn, addColumn, addRow, addRowWithValuesInColumns, addWorksheetMetadata, checkThatWorksheetExists, deleteRow, findRows, getAlias, getColumn, getColumn, getDoesNotExistInSpreadsheet, getExistsInSpreadsheet, getHeader, getModel, getName, getNonexistentWorksheetMessage, getValuesForEmptyRow, isDataTypeStrict, isIdentifiablyBy, toString

Methods inherited from class java.lang.Object

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

Field Details

model

protected ExcelModel model

sheet

protected org.apache.poi.ss.usermodel.Sheet sheet

Constructor Details

ExcelWorksheet

public ExcelWorksheet(ExcelModel model,
 org.apache.poi.ss.usermodel.Sheet sheet,
 boolean existsInSpreadsheet)

Method Details

createInSpreadsheet

protected void createInSpreadsheet()

Description copied from class: SpreadsheetWorksheet

The purpose of this method is to create this worksheet in the spreadsheet

Specified by:

createInSpreadsheet in class SpreadsheetWorksheet

loadHeader

protected void loadHeader()

Description copied from class: SpreadsheetWorksheet

Loads header row information - index and name - from the spreadsheet if the worksheet exists in the spreadsheet

Specified by:

loadHeader in class SpreadsheetWorksheet

createColumn

protected SpreadsheetColumn createColumn(int index)

Description copied from class: SpreadsheetWorksheet

Creates a column with the specified column index

Specified by:

createColumn in class SpreadsheetWorksheet

Returns:

column

getRows

public List<SpreadsheetRow> getRows()

Description copied from class: SpreadsheetWorksheet

Gets all rows contained by the worksheet

Specified by:

getRows in class SpreadsheetWorksheet

Returns:

List of rows

insertRow

public SpreadsheetRow insertRow(Map<SpreadsheetColumn,String> values)

Description copied from class: SpreadsheetWorksheet

Inserts a new row in the worksheet with given values in the given columns.

Specified by:

insertRow in class SpreadsheetWorksheet

Returns:

the newly created row

removeRow

public void removeRow(SpreadsheetRow row)

Description copied from class: SpreadsheetWorksheet

Deletes the given row from the actual worksheet.

Specified by:

removeRow in class SpreadsheetWorksheet

getDefaultEmptyCellValue

public String getDefaultEmptyCellValue()

Description copied from class: SpreadsheetWorksheet

This method returns the default value to be written to a cell when a new empty row is created in a worksheet that is not enforcing data type strictness.

Specified by:

getDefaultEmptyCellValue in class SpreadsheetWorksheet

Returns:

String

getHeaderRowIndex

public int getHeaderRowIndex()

getFirstRowIndex

public int getFirstRowIndex()