Package adams.data.conversion
Class SpreadSheetToMap
- java.lang.Object
-
- adams.core.logging.LoggingObject
-
- adams.core.logging.CustomLoggingLevelObject
-
- adams.core.option.AbstractOptionHandler
-
- adams.data.conversion.AbstractConversion
-
- adams.data.conversion.SpreadSheetToMap
-
- All Implemented Interfaces:
AdditionalInformationHandler,CleanUpHandler,Destroyable,GlobalInfoSupporter,LoggingLevelHandler,LoggingSupporter,OptionHandler,QuickInfoSupporter,ShallowCopySupporter<AbstractConversion>,SizeOfHandler,Stoppable,Conversion,Serializable
public class SpreadSheetToMap extends AbstractConversion
Turns two columns (key and value) of a spreadsheet into a map object of the specified type.
-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel) The logging level for outputting errors and debugging output. default: WARNING
-key-column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: keyColumn) The column in the spreadsheet to act as the 'key' for the values. default: 1 example: An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
-value-column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: valueColumn) The column in the spreadsheet to stores the 'values'. default: 2 example: An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
-map-class <adams.core.base.BaseClassname> (property: mapClass) The type of map to instantiate and fill. default: java.util.HashMap
- Version:
- $Revision$
- Author:
- fracpete (fracpete at waikato dot ac dot nz)
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description protected SpreadSheetColumnIndexm_KeyColumnthe key colum.protected BaseClassnamem_MapClassthe map class to use.protected SpreadSheetColumnIndexm_ValueColumnthe value colum.-
Fields inherited from class adams.data.conversion.AbstractConversion
m_Input, m_Output, m_Owner, m_Stopped
-
Fields inherited from class adams.core.option.AbstractOptionHandler
m_OptionManager
-
Fields inherited from class adams.core.logging.LoggingObject
m_Logger, m_LoggingIsEnabled, m_LoggingLevel
-
-
Constructor Summary
Constructors Constructor Description SpreadSheetToMap()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description Classaccepts()Returns the class that is accepted as input.voiddefineOptions()Adds options to the internal list of options.protected ObjectdoConvert()Performs the actual conversion.Classgenerates()Returns the class that is generated as output.SpreadSheetColumnIndexgetKeyColumn()Returns the key column.BaseClassnamegetMapClass()Returns the map class.SpreadSheetColumnIndexgetValueColumn()Returns the value column.StringglobalInfo()Returns a string describing the object.StringkeyColumnTipText()Returns the tip text for this property.StringmapClassTipText()Returns the tip text for this property.voidsetKeyColumn(SpreadSheetColumnIndex value)Sets the key column.voidsetMapClass(BaseClassname value)Sets the map class.voidsetValueColumn(SpreadSheetColumnIndex value)Sets the value column.StringvalueColumnTipText()Returns the tip text for this property.-
Methods inherited from class adams.data.conversion.AbstractConversion
checkData, cleanUp, convert, getAdditionalInformation, getInput, getInput, getOutput, getOutput, getOwner, getQuickInfo, reset, setInput, setOwner, shallowCopy, shallowCopy, stopExecution
-
Methods inherited from class adams.core.option.AbstractOptionHandler
cleanUpOptions, destroy, finishInit, getDefaultLoggingLevel, getOptionManager, initialize, loggingLevelTipText, newOptionManager, setLoggingLevel, toCommandLine, toString
-
Methods inherited from class adams.core.logging.LoggingObject
configureLogger, getLogger, getLoggingLevel, initializeLogging, isLoggingEnabled, sizeOf
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface adams.core.logging.LoggingLevelHandler
getLoggingLevel
-
-
-
-
Field Detail
-
m_KeyColumn
protected SpreadSheetColumnIndex m_KeyColumn
the key colum.
-
m_ValueColumn
protected SpreadSheetColumnIndex m_ValueColumn
the value colum.
-
m_MapClass
protected BaseClassname m_MapClass
the map class to use.
-
-
Method Detail
-
globalInfo
public String globalInfo()
Returns a string describing the object.- Specified by:
globalInfoin interfaceGlobalInfoSupporter- Specified by:
globalInfoin classAbstractOptionHandler- Returns:
- a description suitable for displaying in the gui
-
defineOptions
public void defineOptions()
Adds options to the internal list of options.- Specified by:
defineOptionsin interfaceOptionHandler- Overrides:
defineOptionsin classAbstractOptionHandler
-
setKeyColumn
public void setKeyColumn(SpreadSheetColumnIndex value)
Sets the key column.- Parameters:
value- the column
-
getKeyColumn
public SpreadSheetColumnIndex getKeyColumn()
Returns the key column.- Returns:
- the column
-
keyColumnTipText
public String keyColumnTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setValueColumn
public void setValueColumn(SpreadSheetColumnIndex value)
Sets the value column.- Parameters:
value- the column
-
getValueColumn
public SpreadSheetColumnIndex getValueColumn()
Returns the value column.- Returns:
- the column
-
valueColumnTipText
public String valueColumnTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setMapClass
public void setMapClass(BaseClassname value)
Sets the map class.- Parameters:
value- the map class
-
getMapClass
public BaseClassname getMapClass()
Returns the map class.- Returns:
- the map class
-
mapClassTipText
public String mapClassTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
accepts
public Class accepts()
Returns the class that is accepted as input.- Specified by:
acceptsin interfaceConversion- Specified by:
acceptsin classAbstractConversion- Returns:
- the class
-
generates
public Class generates()
Returns the class that is generated as output.- Specified by:
generatesin interfaceConversion- Specified by:
generatesin classAbstractConversion- Returns:
- the class
-
doConvert
protected Object doConvert() throws Exception
Performs the actual conversion.- Specified by:
doConvertin classAbstractConversion- Returns:
- the converted data
- Throws:
Exception- if something goes wrong with the conversion
-
-