Package adams.data.conversion
Class SpreadSheetRowsToReport
- java.lang.Object
-
- adams.core.logging.LoggingObject
-
- adams.core.logging.CustomLoggingLevelObject
-
- adams.core.option.AbstractOptionHandler
-
- adams.data.conversion.AbstractConversion
-
- adams.data.conversion.SpreadSheetRowsToReport
-
- All Implemented Interfaces:
AdditionalInformationHandler
,CleanUpHandler
,Destroyable
,GlobalInfoSupporter
,LenientModeSupporter
,LoggingLevelHandler
,LoggingSupporter
,OptionHandler
,QuickInfoSupporter
,ShallowCopySupporter<AbstractConversion>
,SizeOfHandler
,Stoppable
,Conversion
,Serializable
public class SpreadSheetRowsToReport extends AbstractConversion implements LenientModeSupporter
Turns spreadsheet rows into report.
-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel) The logging level for outputting errors and debugging output. default: WARNING
-row-report-names <adams.data.spreadsheet.SpreadSheetRowIndex> (property: rowReportNames) The (optional) row that contains the report names. default: example: An index is a number starting with 1; the following placeholders can be used as well: first, second, third, last_2, last_1, last
-report-names-in-header <boolean> (property: reportNamesInHeader) Whether the report names are stored in the header. default: false
-rows-report-values <adams.data.spreadsheet.SpreadSheetRowRange> (property: rowsReportValues) The rows in the spreadsheet that contain the report values. default: example: A range is a comma-separated list of single 1-based indices or sub-ranges of indices ('start-end'); 'inv(...)' inverts the range '...'; the following placeholders can be used as well: first, second, third, last_2, last_1, last
-cols-report <adams.data.spreadsheet.SpreadSheetColumnRange> (property: columnsReport) The columns that contain report. default: example: A range is a comma-separated list of single 1-based indices or sub-ranges of indices ('start-end'); 'inv(...)' inverts the range '...'; 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.
-lenient <boolean> (property: lenient) If enabled, then errors (e.g., due to corrupt data) will not cause exceptions. default: false
- Author:
- fracpete (fracpete at waikato dot ac dot nz)
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description protected SpreadSheetColumnRange
m_ColumnsReport
the rows to get the report from.protected boolean
m_Lenient
whether to skip over errors.protected boolean
m_ReportNamesInHeader
whether the report names are in the header row.protected SpreadSheetRowIndex
m_RowReportNames
the column with the report names.protected SpreadSheetRowRange
m_RowsReportValues
the rows with report values.-
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 SpreadSheetRowsToReport()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description Class
accepts()
Returns the class that is accepted as input.String
columnsReportTipText()
Returns the tip text for this property.void
defineOptions()
Adds options to the internal list of options.protected Object
doConvert()
Performs the actual conversion.Class
generates()
Returns the class that is generated as output.SpreadSheetColumnRange
getColumnsReport()
Returns the columns with report.boolean
getLenient()
Returns whether whether to skip over errors.String
getQuickInfo()
Returns a quick info about the object, which can be displayed in the GUI.boolean
getReportNamesInHeader()
Returns whether the report names are in the header.SpreadSheetRowIndex
getRowReportNames()
Returns the row that contains the report names.SpreadSheetRowRange
getRowsReportValues()
Returns the rows with the report values.String
globalInfo()
Returns a string describing the object.String
lenientTipText()
Returns the tip text for this property.String
reportNamesInHeaderTipText()
Returns the tip text for this property.String
rowReportNamesTipText()
Returns the tip text for this property.String
rowsReportValuesTipText()
Returns the tip text for this property.void
setColumnsReport(SpreadSheetColumnRange value)
Sets the columns with report.void
setLenient(boolean value)
Sets whether to skip over errors.void
setReportNamesInHeader(boolean value)
Sets whether the wave numbers are in the header.void
setRowReportNames(SpreadSheetRowIndex value)
Sets the row that contains the report names.void
setRowsReportValues(SpreadSheetRowRange value)
Sets the rows with the report values.-
Methods inherited from class adams.data.conversion.AbstractConversion
checkData, cleanUp, convert, getAdditionalInformation, getInput, getInput, getOutput, getOutput, getOwner, 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_RowReportNames
protected SpreadSheetRowIndex m_RowReportNames
the column with the report names.
-
m_ReportNamesInHeader
protected boolean m_ReportNamesInHeader
whether the report names are in the header row.
-
m_RowsReportValues
protected SpreadSheetRowRange m_RowsReportValues
the rows with report values.
-
m_ColumnsReport
protected SpreadSheetColumnRange m_ColumnsReport
the rows to get the report from.
-
m_Lenient
protected boolean m_Lenient
whether to skip over errors.
-
-
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
-
defineOptions
public void defineOptions()
Adds options to the internal list of options.- Specified by:
defineOptions
in interfaceOptionHandler
- Overrides:
defineOptions
in classAbstractOptionHandler
-
setRowReportNames
public void setRowReportNames(SpreadSheetRowIndex value)
Sets the row that contains the report names.- Parameters:
value
- the row
-
getRowReportNames
public SpreadSheetRowIndex getRowReportNames()
Returns the row that contains the report names.- Returns:
- the row
-
rowReportNamesTipText
public String rowReportNamesTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setReportNamesInHeader
public void setReportNamesInHeader(boolean value)
Sets whether the wave numbers are in the header.- Parameters:
value
- true if in header
-
getReportNamesInHeader
public boolean getReportNamesInHeader()
Returns whether the report names are in the header.- Returns:
- true if in header
-
reportNamesInHeaderTipText
public String reportNamesInHeaderTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setColumnsReport
public void setColumnsReport(SpreadSheetColumnRange value)
Sets the columns with report.- Parameters:
value
- the columns
-
getColumnsReport
public SpreadSheetColumnRange getColumnsReport()
Returns the columns with report.- Returns:
- the columns
-
columnsReportTipText
public String columnsReportTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setRowsReportValues
public void setRowsReportValues(SpreadSheetRowRange value)
Sets the rows with the report values.- Parameters:
value
- the rows
-
getRowsReportValues
public SpreadSheetRowRange getRowsReportValues()
Returns the rows with the report values.- Returns:
- the rows
-
rowsReportValuesTipText
public String rowsReportValuesTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setLenient
public void setLenient(boolean value)
Sets whether to skip over errors.- Specified by:
setLenient
in interfaceLenientModeSupporter
- Parameters:
value
- true if to skip
-
getLenient
public boolean getLenient()
Returns whether whether to skip over errors.- Specified by:
getLenient
in interfaceLenientModeSupporter
- Returns:
- true if to skip
-
lenientTipText
public String lenientTipText()
Returns the tip text for this property.- Specified by:
lenientTipText
in interfaceLenientModeSupporter
- 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:
accepts
in interfaceConversion
- Specified by:
accepts
in classAbstractConversion
- Returns:
- the class
-
generates
public Class generates()
Returns the class that is generated as output.- Specified by:
generates
in interfaceConversion
- Specified by:
generates
in classAbstractConversion
- Returns:
- the class
-
getQuickInfo
public String getQuickInfo()
Returns a quick info about the object, which can be displayed in the GUI.- Specified by:
getQuickInfo
in interfaceQuickInfoSupporter
- Overrides:
getQuickInfo
in classAbstractConversion
- Returns:
- null if no info available, otherwise short string
-
doConvert
protected Object doConvert() throws Exception
Performs the actual conversion.- Specified by:
doConvert
in classAbstractConversion
- Returns:
- the converted data
- Throws:
Exception
- if something goes wrong with the conversion
-
-