org.eclipse.epsilon.emc.spreadsheets.excel

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:

AutoCloseable, IModel, ISearchableModel

Direct Known Subclasses:

SecureExcelModel

public class ExcelModel
extends SpreadsheetModel

Field Summary

Fields

Modifier and Type	Field and Description
static String	CONFIGURATION_FILE
static String	SPREADSHEET_FILE
static 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 and Description
ExcelModel()

Method Summary

Modifier and Type	Method and 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 spreadsheet
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 model
protected boolean	isMetadataConfigurationDefined()
void	load(StringProperties properties, IRelativePathResolver resolver)
protected void	loadSpreadsheet() The purpose of this method is to load the spreadsheet.
static void	main(String[] args)
void	setConfigurationFile(String configurationFilePath)
void	setPassword(String password)
void	setSpreadsheetFile(String pathToSpreadsheet)
boolean	store()
boolean	store(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

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.eclipse.epsilon.eol.models.IModel

close

Field Detail

SPREADSHEET_FILE

public static final String SPREADSHEET_FILE

See Also:

Constant Field Values

CONFIGURATION_FILE

public static final String CONFIGURATION_FILE

See Also:

Constant Field Values

SPREADSHEET_PASSWORD

public static final String SPREADSHEET_PASSWORD

See Also:

Constant Field Values

workbook

protected org.apache.poi.ss.usermodel.Workbook workbook

Constructor Detail

ExcelModel

public ExcelModel()

Method Detail

main

public static void main(String[] args)
                 throws Exception

Throws:

Exception

setSpreadsheetFile

public void setSpreadsheetFile(String pathToSpreadsheet)

setConfigurationFile

public void setConfigurationFile(String configurationFilePath)
                          throws ParserConfigurationException,
                                 SAXException,
                                 IOException

Throws:

ParserConfigurationException

SAXException

IOException

setPassword

public void setPassword(String password)

load

public void load(StringProperties properties,
                 IRelativePathResolver resolver)
          throws EolModelLoadingException

Specified by:

load in interface IModel

Overrides:

load in class Model

Throws:

EolModelLoadingException

loadSpreadsheet

protected void loadSpreadsheet()
                        throws Exception

Description copied from class: SpreadsheetModel

The purpose of this method is to load the spreadsheet.

Specified by:

loadSpreadsheet in class SpreadsheetModel

Throws:

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 class SpreadsheetModel

isMetadataConfigurationDefined

protected boolean isMetadataConfigurationDefined()

Specified by:

isMetadataConfigurationDefined in class SpreadsheetModel

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 class SpreadsheetModel

Returns:

newly created worksheet

store

public boolean store(String location)

Specified by:

store in interface IModel

Overrides:

store in class SpreadsheetModel

store

public boolean store()

Specified by:

store in interface IModel

Overrides:

store in class SpreadsheetModel

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 class SpreadsheetModel

find

public Collection<SpreadsheetRow> find(Variable iterator,
                                       ModuleElement ast,
                                       IEolContext context)
                                throws EolRuntimeException

Specified by:

find in interface ISearchableModel

Specified by:

find in class SpreadsheetModel

Throws:

EolRuntimeException