java.lang.Object
- adams.core.logging.LoggingObject
- - adams.core.logging.CustomLoggingLevelObject
  - - adams.core.option.AbstractOptionHandler
    - - adams.data.conversion.AbstractConversion
      - adams.data.conversion.AbstractSpreadSheetConversion
        
        adams.data.conversion.AbstractInPlaceSpreadSheetConversion
        
        adams.data.conversion.AbstractSpreadSheetColumnConverter
        
        adams.data.conversion.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

- Field Detail
  - m_Calendar
```
protected Calendar m_Calendar
```
    the calendar to use.
  - m_StartDate
```
protected Date m_StartDate
```
    the start date.
- Constructor Detail
  - ExcelDoubleColumnToDate
```
public ExcelDoubleColumnToDate()
```
- Method Detail
  - globalInfo
```
public String globalInfo()
```
    Returns a string describing the object.
    
    Specified by:
    
    globalInfo in interface GlobalInfoSupporter
    
    Specified by:
    
    globalInfo in class AbstractOptionHandler
    
    Returns:
    
    a description suitable for displaying in the gui
  - columnTipText
```
public String columnTipText()
```
    Returns the tip text for this property.
    
    Specified by:
    
    columnTipText in class AbstractSpreadSheetColumnConverter
    
    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 class AbstractConversion
    
    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 class AbstractSpreadSheetColumnConverter
    
    Parameters:
    
    cellOld - the current cell
    
    cellNew - the new cell with the converted content
    
    Throws:
    
    Exception - if conversion fails

Modifier and Type	Field	Description
`protected Calendar`	`m_Calendar`	the calendar to use.
`protected Date`	`m_StartDate`	the start date.

Class ExcelDoubleColumnToDate

Field Summary

Fields inherited from class adams.data.conversion.AbstractSpreadSheetColumnConverter

Fields inherited from class adams.data.conversion.AbstractInPlaceSpreadSheetConversion

Fields inherited from class adams.data.conversion.AbstractConversion

Fields inherited from class adams.core.option.AbstractOptionHandler

Fields inherited from class adams.core.logging.LoggingObject

Constructor Summary

Method Summary

Methods inherited from class adams.data.conversion.AbstractSpreadSheetColumnConverter

Methods inherited from class adams.data.conversion.AbstractInPlaceSpreadSheetConversion

Methods inherited from class adams.data.conversion.AbstractSpreadSheetConversion

Methods inherited from class adams.data.conversion.AbstractConversion

Methods inherited from class adams.core.option.AbstractOptionHandler

Methods inherited from class adams.core.logging.LoggingObject

Methods inherited from class java.lang.Object

Methods inherited from interface adams.core.logging.LoggingLevelHandler

Field Detail

m_Calendar

m_StartDate

Constructor Detail

ExcelDoubleColumnToDate

Method Detail

globalInfo

columnTipText

checkData

convert