Class ExcelModel
- java.lang.Object
-
- org.eclipse.epsilon.eol.models.Model
-
- org.eclipse.epsilon.emc.spreadsheets.SpreadsheetModel
-
- org.eclipse.epsilon.emc.spreadsheets.excel.ExcelModel
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,IModel
,ISearchableModel
- Direct Known Subclasses:
SecureExcelModel
public class ExcelModel extends SpreadsheetModel
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.String
CONFIGURATION_FILE
static java.lang.String
SPREADSHEET_FILE
static java.lang.String
SPREADSHEET_PASSWORD
protected org.apache.poi.ss.usermodel.Workbook
workbook
-
Fields inherited from class org.eclipse.epsilon.emc.spreadsheets.SpreadsheetModel
isLoaded, references, worksheets
-
Fields inherited from class org.eclipse.epsilon.eol.models.Model
aliases, ENV_PREFIX, name, PROPERTY_ALIASES, PROPERTY_NAME, PROPERTY_READONLOAD, PROPERTY_READONLY, PROPERTY_STOREONDISPOSAL, propertyGetter, propertySetter, readOnLoad, storeOnDisposal
-
-
Constructor Summary
Constructors Constructor Description ExcelModel()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description protected ExcelWorksheet
createWorksheet(ISpreadsheetMetadata.SpreadsheetWorksheetMetadata worksheetMetadata)
The purpose of this method is to create a worksheet.void
deleteWorksheet(SpreadsheetWorksheet worksheet)
The purpose of this method is to delete the given worksheet from this spreadsheetjava.util.Collection<SpreadsheetRow>
find(Variable iterator, ModuleElement ast, IEolContext context)
protected ISpreadsheetMetadata
getSpreadsheetMetadata()
The purpose of this method is to return an instance of the ISpreadsheetMetadata implementation for retrieving metadata for this spreadsheet modelprotected boolean
isMetadataConfigurationDefined()
void
load(StringProperties properties, IRelativePathResolver resolver)
protected void
loadSpreadsheet()
The purpose of this method is to load the spreadsheet.static void
main(java.lang.String[] args)
void
setConfigurationFile(java.lang.String configurationFilePath)
void
setPassword(java.lang.String password)
void
setSpreadsheetFile(java.lang.String pathToSpreadsheet)
boolean
store()
boolean
store(java.lang.String location)
-
Methods inherited from class org.eclipse.epsilon.emc.spreadsheets.SpreadsheetModel
addReference, addWorksheet, allContents, createInstance, createInstance, createInstance, deleteElement, dispose, findOne, getAllOfKind, getAllOfType, getElementById, getElementId, getEnumerationValue, getPropertySetter, getReferences, getReferencesBySource, getReferencesBySource, getReferencesByTarget, getReferencesByTarget, getTypeNameOf, getTypeOf, getWorksheetByType, getWorksheets, hasType, isInstantiable, isLoaded, load, loadColumnsFromMetadata, loadConfigurationFile, loadReferenceFromConfigurationFile, loadWorksheetFromConfigurationFile, owns, setElementId
-
Methods inherited from class org.eclipse.epsilon.eol.models.Model
allInstances, getAliases, getFullyQualifiedTypeNameOf, getMetamodel, getName, getPropertyGetter, getTransactionSupport, isModelElement, isOfKind, isOfType, isPropertySet, isReadOnLoad, isStoredOnDisposal, knowsAboutProperty, load, load, setName, setReadOnLoad, setStoredOnDisposal
-
-
-
-
Field Detail
-
SPREADSHEET_FILE
public static final java.lang.String SPREADSHEET_FILE
- See Also:
- Constant Field Values
-
CONFIGURATION_FILE
public static final java.lang.String CONFIGURATION_FILE
- See Also:
- Constant Field Values
-
SPREADSHEET_PASSWORD
public static final java.lang.String SPREADSHEET_PASSWORD
- See Also:
- Constant Field Values
-
workbook
protected org.apache.poi.ss.usermodel.Workbook workbook
-
-
Method Detail
-
main
public static void main(java.lang.String[] args) throws java.lang.Exception
- Throws:
java.lang.Exception
-
setSpreadsheetFile
public void setSpreadsheetFile(java.lang.String pathToSpreadsheet)
-
setConfigurationFile
public void setConfigurationFile(java.lang.String configurationFilePath) throws javax.xml.parsers.ParserConfigurationException, org.xml.sax.SAXException, java.io.IOException
- Throws:
javax.xml.parsers.ParserConfigurationException
org.xml.sax.SAXException
java.io.IOException
-
setPassword
public void setPassword(java.lang.String password)
-
load
public void load(StringProperties properties, IRelativePathResolver resolver) throws EolModelLoadingException
- Specified by:
load
in interfaceIModel
- Overrides:
load
in classModel
- Throws:
EolModelLoadingException
-
loadSpreadsheet
protected void loadSpreadsheet() throws java.lang.Exception
Description copied from class:SpreadsheetModel
The purpose of this method is to load the spreadsheet.- Specified by:
loadSpreadsheet
in classSpreadsheetModel
- Throws:
java.lang.Exception
-
getSpreadsheetMetadata
protected ISpreadsheetMetadata getSpreadsheetMetadata()
Description copied from class:SpreadsheetModel
The purpose of this method is to return an instance of the ISpreadsheetMetadata implementation for retrieving metadata for this spreadsheet model- Specified by:
getSpreadsheetMetadata
in classSpreadsheetModel
-
isMetadataConfigurationDefined
protected boolean isMetadataConfigurationDefined()
- Specified by:
isMetadataConfigurationDefined
in classSpreadsheetModel
- Returns:
- true if metadata has been provided, false otherwise
-
createWorksheet
protected ExcelWorksheet createWorksheet(ISpreadsheetMetadata.SpreadsheetWorksheetMetadata worksheetMetadata)
Description copied from class:SpreadsheetModel
The purpose of this method is to create a worksheet.- Specified by:
createWorksheet
in classSpreadsheetModel
- Returns:
- newly created worksheet
-
store
public boolean store(java.lang.String location)
- Specified by:
store
in interfaceIModel
- Overrides:
store
in classSpreadsheetModel
-
store
public boolean store()
- Specified by:
store
in interfaceIModel
- Overrides:
store
in classSpreadsheetModel
-
deleteWorksheet
public void deleteWorksheet(SpreadsheetWorksheet worksheet)
Description copied from class:SpreadsheetModel
The purpose of this method is to delete the given worksheet from this spreadsheet- Specified by:
deleteWorksheet
in classSpreadsheetModel
-
find
public java.util.Collection<SpreadsheetRow> find(Variable iterator, ModuleElement ast, IEolContext context) throws EolRuntimeException
- Specified by:
find
in interfaceISearchableModel
- Specified by:
find
in classSpreadsheetModel
- Throws:
EolRuntimeException
-
-