Package es.urjc.etsii.grafo.io.serializers.excel

Class ExcelSerializer<S extends Solution<S,I>,I extends Instance>

java.lang.Object

es.urjc.etsii.grafo.io.serializers.ResultsSerializer<S,I>

es.urjc.etsii.grafo.io.serializers.excel.ExcelSerializer<S,I>

public class ExcelSerializer<S extends Solution<S,I>,I extends Instance>
extends ResultsSerializer<S,I>

Serialize results to Excel XML format

Field Summary

Fields

Modifier and Type	Field	Description
static final String	INSTANCE_SHEET	Instance data sheet
static final double	NEGATIVE_INFINITY	Negative infinity value to use in Excel
static final String	OTHER_DATA_SHEET	Sheet name where common data such as VM version, benchmark score, etc will be stored
static final String	PIVOT_SHEET	Pivot table sheet name
static final double	POSITIVE_INFINITY	Positive infinity value to use in Excel
static final String	RAW_SHEET	Raw sheet name

Fields inherited from class es.urjc.etsii.grafo.io.serializers.ResultsSerializer

referenceResultProviders

Constructor Summary

Constructors

Constructor	Description
ExcelSerializer(ExcelConfig serializerConfig, List<ReferenceResultProvider> referenceResultProviders, Optional<ExcelCustomizer> excelCustomizer, InstanceManager<I> instanceManager)	Create an Excel serializer

Method Summary

Modifier and Type	Method	Description
void	_serializeResults(String experimentName, List<SolutionGeneratedEvent<S,I>> results, Path p)	This procedure serialize the list of results to a specific format and generate the resultant file in a given path
protected void	fillInstanceSheet(String expName, org.apache.poi.xssf.usermodel.XSSFWorkbook excelBook)
protected static RawSheetWriter	getRawSheetWriter(ExcelConfig config, List<? extends SolutionGeneratedEvent<?,?>> results)

Methods inherited from class es.urjc.etsii.grafo.io.serializers.ResultsSerializer

getConfig, serializeResults

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

RAW_SHEET

public static final String RAW_SHEET

Raw sheet name

See Also:

• Constant Field Values

PIVOT_SHEET

public static final String PIVOT_SHEET

Pivot table sheet name

See Also:

• Constant Field Values

OTHER_DATA_SHEET

public static final String OTHER_DATA_SHEET

Sheet name where common data such as VM version, benchmark score, etc will be stored

See Also:

• Constant Field Values

INSTANCE_SHEET

public static final String INSTANCE_SHEET

Instance data sheet

See Also:

• Constant Field Values

POSITIVE_INFINITY

public static final double POSITIVE_INFINITY

Positive infinity value to use in Excel

See Also:

• Constant Field Values

NEGATIVE_INFINITY

public static final double NEGATIVE_INFINITY

Negative infinity value to use in Excel

See Also:

• Constant Field Values

Constructor Details

ExcelSerializer

public ExcelSerializer(ExcelConfig serializerConfig,
 List<ReferenceResultProvider> referenceResultProviders,
 Optional<ExcelCustomizer> excelCustomizer,
 InstanceManager<I> instanceManager)

Create an Excel serializer

Parameters:

serializerConfig - excel serializer configuration

referenceResultProviders - reference result providers if available

excelCustomizer - customizer if available

instanceManager -

Method Details

_serializeResults

public void _serializeResults(String experimentName,
 List<SolutionGeneratedEvent<S,I>> results,
 Path p)

This procedure serialize the list of results to a specific format and generate the resultant file in a given path

Specified by:

_serializeResults in class ResultsSerializer<S extends Solution<S,I>,I extends Instance>

Parameters:

results - list of results

p - path

fillInstanceSheet

protected void fillInstanceSheet(String expName,
 org.apache.poi.xssf.usermodel.XSSFWorkbook excelBook)

getRawSheetWriter

protected static RawSheetWriter getRawSheetWriter(ExcelConfig config,
 List<? extends SolutionGeneratedEvent<?,?>> results)