Package adams.data.conversion
Class ExcelDoubleColumnToDate
-
- All Implemented Interfaces:
AdditionalInformationHandler
,CleanUpHandler
,Destroyable
,GlobalInfoSupporter
,LoggingLevelHandler
,LoggingSupporter
,OptionHandler
,QuickInfoSupporter
,ShallowCopySupporter
,SizeOfHandler
,Stoppable
,Conversion
,InPlaceProcessing
,Serializable
public class ExcelDoubleColumnToDate extends AbstractSpreadSheetColumnConverter
Converts the specified double column to a date column.
Valid options are:
-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel) The logging level for outputting errors and debugging output. default: WARNING
-no-copy <boolean> (property: noCopy) If enabled, no copy of the spreadsheet is created before processing it. default: false
-column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: column) The double column to convert to date; An index is a number starting with 1; apart from column names (case-sensitive), the following placeholders can be used as well: first, second, third, last_2, last_1, last default: first
- Version:
- $Revision$
- Author:
- fracpete (fracpete at waikato dot ac dot nz)
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description protected Calendar
m_Calendar
the calendar to use.protected Date
m_StartDate
the start date.-
Fields inherited from class adams.data.conversion.AbstractSpreadSheetColumnConverter
m_Column, m_KeepFailed
-
Fields inherited from class adams.data.conversion.AbstractInPlaceSpreadSheetConversion
m_NoCopy
-
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 ExcelDoubleColumnToDate()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected String
checkData()
Checks whether the data can be processed.String
columnTipText()
Returns the tip text for this property.protected void
convert(Cell cellOld, Cell cellNew)
Converts the cell's content to a new format.String
globalInfo()
Returns a string describing the object.-
Methods inherited from class adams.data.conversion.AbstractSpreadSheetColumnConverter
convert, defineOptions, getColumn, getKeepFailed, keepFailedTipText, preConvert, setColumn, setKeepFailed
-
Methods inherited from class adams.data.conversion.AbstractInPlaceSpreadSheetConversion
getNoCopy, noCopyTipText, setNoCopy
-
Methods inherited from class adams.data.conversion.AbstractSpreadSheetConversion
accepts, doConvert, generates
-
Methods inherited from class adams.data.conversion.AbstractConversion
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
-
-
-
-
Method Detail
-
globalInfo
public String globalInfo()
Returns a string describing the object.- Specified by:
globalInfo
in interfaceGlobalInfoSupporter
- Specified by:
globalInfo
in classAbstractOptionHandler
- Returns:
- a description suitable for displaying in the gui
-
columnTipText
public String columnTipText()
Returns the tip text for this property.- Specified by:
columnTipText
in classAbstractSpreadSheetColumnConverter
- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
checkData
protected String checkData()
Checks whether the data can be processed.- Overrides:
checkData
in classAbstractConversion
- Returns:
- null if checks passed, otherwise error message
-
convert
protected void convert(Cell cellOld, Cell cellNew) throws Exception
Converts the cell's content to a new format.- Specified by:
convert
in classAbstractSpreadSheetColumnConverter
- Parameters:
cellOld
- the current cellcellNew
- the new cell with the converted content- Throws:
Exception
- if conversion fails
-
-