public interface Sheet extends MDWEObject, EModelElement
The following features are supported:
ExcelPackage.getSheet()
Modifier and Type | Method and Description |
---|---|
void |
addColumns()
Creates the necessary columns based on existing rows and cells.
|
CellRegion |
addMergedRegion(int firstRow,
int lastRow,
int firstColumn,
int lastColumn)
Creates a merged region for the specified rows and columns.
|
Row |
addRow()
Creates a new row below the last known row of this sheet.
|
MDWEList<Column> |
getColumns()
Returns the value of the 'Columns' containment reference list.
|
float |
getDefaultColumnWidth()
Returns the value of the 'Default Column Width' attribute.
|
float |
getDefaultRowHeight()
Returns the value of the 'Default Row Height' attribute.
|
MDWEList<CellRegion> |
getMergedRegions()
Returns the value of the 'Merged Regions' containment reference list.
|
String |
getName()
Returns the value of the 'Name' attribute.
|
MDWEList<Row> |
getRows()
Returns the value of the 'Rows' containment reference list.
|
Workbook |
getWorkbook()
Returns the value of the 'Workbook' container reference.
|
void |
setDefaultColumnWidth(float value)
Sets the value of the '
Default Column Width ' attribute. |
void |
setDefaultRowHeight(float value)
Sets the value of the '
Default Row Height ' attribute. |
void |
setName(String value)
Sets the value of the '
Name ' attribute. |
void |
setWorkbook(Workbook value)
Sets the value of the '
Workbook ' container reference. |
compareTo, eExtendedClass, eIsInstanceOf, eIsInstanceOf, eIsProfiled, eIsRemoved, eMetamodel, eMetaTypeName, eModel, eRemove, eSetUniqueID, eUniqueID, superScript, superScript, toBoolean, toBoolean, toByte, toByte, toChar, toChar, toDouble, toDouble, toFloat, toFloat, toInt, toInt, toList, toList, toList, toList, toList, toLong, toLong, toObject, toObject, toSet, toSet, toShort, toShort, toString, toString
getEAnnotation, getEAnnotations
eAllContents, eClass, eContainer, eContainingFeature, eContainmentFeature, eContents, eCrossReferences, eGet, eGet, eInvoke, eIsProxy, eIsSet, eResource, eSet, eUnset
eAdapters, eDeliver, eNotify, eSetDeliver
MDWEList<Row> getRows()
Row
.
It is bidirectional and its opposite is 'Sheet
'.
ExcelPackage.getSheet_Rows()
,
Row.getSheet()
String getName()
""
.
setName(String)
,
ExcelPackage.getSheet_Name()
void setName(String value)
Name
' attribute.
value
- the new value of the 'Name' attribute.getName()
MDWEList<CellRegion> getMergedRegions()
CellRegion
.
ExcelPackage.getSheet_MergedRegions()
float getDefaultRowHeight()
setDefaultRowHeight(float)
,
ExcelPackage.getSheet_DefaultRowHeight()
void setDefaultRowHeight(float value)
Default Row Height
' attribute.
value
- the new value of the 'Default Row Height' attribute.getDefaultRowHeight()
float getDefaultColumnWidth()
setDefaultColumnWidth(float)
,
ExcelPackage.getSheet_DefaultColumnWidth()
void setDefaultColumnWidth(float value)
Default Column Width
' attribute.
value
- the new value of the 'Default Column Width' attribute.getDefaultColumnWidth()
MDWEList<Column> getColumns()
Column
.
It is bidirectional and its opposite is 'Sheet
'.
ExcelPackage.getSheet_Columns()
,
Column.getSheet()
Workbook getWorkbook()
Sheets
'.
setWorkbook(Workbook)
,
ExcelPackage.getSheet_Workbook()
,
Workbook.getSheets()
void setWorkbook(Workbook value)
Workbook
' container reference.
value
- the new value of the 'Workbook' container reference.getWorkbook()
void addColumns()
This method determines the maximum number of cells on each row and then ensures the number of columns matches this number of cells, creating columns as needed. Note this method won't remove existing columns if there are more than required given the number of cells.
Clients shall call this method once all necessary rows and cells have been created, so that corresponding columns are automatically added to the model.
Note that column information is not used when writing an Excel workbook. Only rows and cells information is mandatory.
CellRegion addMergedRegion(int firstRow, int lastRow, int firstColumn, int lastColumn)
firstRow
- the row at which the merged region starts.lastRow
- the row at which the merged region ends.firstColumn
- the column at which the merged region starts.lastColumn
- the column at which the merged region ends.Row addRow()