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

Class ExcelCalculatedRawSheetWriter

java.lang.Object

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

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

public class ExcelCalculatedRawSheetWriter
extends RawSheetWriter

Serialize raw sheet using Excel formulas. This method is extremely slow for big quantities of data, but allows to seamlessly add or modify the raw data and recalculate all relevant fields without user intervention.

Nested Class Summary

Nested classes/interfaces inherited from class es.urjc.etsii.grafo.io.serializers.excel.RawSheetWriter

RawSheetWriter.CType

Constructor Summary

Constructors

Constructor	Description
ExcelCalculatedRawSheetWriter()

Method Summary

Modifier and Type	Method	Description
org.apache.poi.ss.util.AreaReference	fillRawSheet(org.apache.poi.xssf.usermodel.XSSFSheet rawSheet, boolean maximizing, List<? extends SolutionGeneratedEvent<?,?>> results, List<ReferenceResultProvider> referenceResultProviders)	Write data to raw sheet

Methods inherited from class es.urjc.etsii.grafo.io.serializers.excel.RawSheetWriter

bestResultPerInstance, getCommonHeaders, getCustomPropertyNames, getPercentageDevToBest, nanInfiniteFilter, writeCell

Methods inherited from class java.lang.Object

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

Constructor Details

ExcelCalculatedRawSheetWriter

public ExcelCalculatedRawSheetWriter()

Method Details

fillRawSheet

public org.apache.poi.ss.util.AreaReference fillRawSheet(org.apache.poi.xssf.usermodel.XSSFSheet rawSheet,
 boolean maximizing,
 List<? extends SolutionGeneratedEvent<?,?>> results,
 List<ReferenceResultProvider> referenceResultProviders)

Write data to raw sheet

Specified by:

fillRawSheet in class RawSheetWriter

Parameters:

rawSheet - sheet reference where data should be written to

maximizing - true if this is a maximizing problem, false otherwise

results - list of results to serialize

referenceResultProviders - reference result providers if available

Returns:

AreaReference specifying the area used in the sheet