it.firegloves.mempoi.domain.footer.NumberAverageSubFooter Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of mempoi Show documentation

A library to simplify export from database to Excel files using Apache POI

There is a newer version: 1.10.1

/**
 * this sub footer shows an average for all the numeric columns in the report
 */

package it.firegloves.mempoi.domain.footer;

public class NumberAverageSubFooter extends NumberFormulaSubFooter {

    @Override
    protected String getFormula(String colLetter, int firstDataRowIndex, int lastDataRowIndex) {
        return "AVERAGE(" + colLetter + firstDataRowIndex + ":" + colLetter + lastDataRowIndex + ")";
    }
}