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 SpreadSheetColumnRangem_ColumnsReportthe rows to get the report from.protected booleanm_Lenientwhether to skip over errors.protected booleanm_ReportNamesInHeaderwhether the report names are in the header row.protected SpreadSheetRowIndexm_RowReportNamesthe column with the report names.protected SpreadSheetRowRangem_RowsReportValuesthe 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 Classaccepts()Returns the class that is accepted as input.StringcolumnsReportTipText()Returns the tip text for this property.voiddefineOptions()Adds options to the internal list of options.protected ObjectdoConvert()Performs the actual conversion.Classgenerates()Returns the class that is generated as output.SpreadSheetColumnRangegetColumnsReport()Returns the columns with report.booleangetLenient()Returns whether whether to skip over errors.StringgetQuickInfo()Returns a quick info about the object, which can be displayed in the GUI.booleangetReportNamesInHeader()Returns whether the report names are in the header.SpreadSheetRowIndexgetRowReportNames()Returns the row that contains the report names.SpreadSheetRowRangegetRowsReportValues()Returns the rows with the report values.StringglobalInfo()Returns a string describing the object.StringlenientTipText()Returns the tip text for this property.StringreportNamesInHeaderTipText()Returns the tip text for this property.StringrowReportNamesTipText()Returns the tip text for this property.StringrowsReportValuesTipText()Returns the tip text for this property.voidsetColumnsReport(SpreadSheetColumnRange value)Sets the columns with report.voidsetLenient(boolean value)Sets whether to skip over errors.voidsetReportNamesInHeader(boolean value)Sets whether the wave numbers are in the header.voidsetRowReportNames(SpreadSheetRowIndex value)Sets the row that contains the report names.voidsetRowsReportValues(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:
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
-
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:
setLenientin interfaceLenientModeSupporter- Parameters:
value- true if to skip
-
getLenient
public boolean getLenient()
Returns whether whether to skip over errors.- Specified by:
getLenientin interfaceLenientModeSupporter- Returns:
- true if to skip
-
lenientTipText
public String lenientTipText()
Returns the tip text for this property.- Specified by:
lenientTipTextin 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:
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
-
getQuickInfo
public String getQuickInfo()
Returns a quick info about the object, which can be displayed in the GUI.- Specified by:
getQuickInfoin interfaceQuickInfoSupporter- Overrides:
getQuickInfoin classAbstractConversion- Returns:
- null if no info available, otherwise short string
-
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
-
-