I want to add SQL Query result to the created Excel File. And as a result, I need to average some columns at the bottom. My question is; The number of rows is changing in some queries. How can I shift the average result by the last row according to the changing row?

example

after writing to excel

I'm learning now to add results using Postgresql to an Excel file created using apache poi.

Resource resource = resourceLoader.getResource("classpath:/temps/" + querySelected.getTemplateName());

workbook = new XSSFWorkbook(resource.getInputStream());
XSSFSheet sheetTable1 = workbook.getSheet("Table1");

int rowCounter = 1;


for (tname:tname) {

    Row values = sheetTable1.createRow(rowCounter);
    rowCounter++;}


    cell = values.createCell(0, CellType.NUMERIC);
    cell.setCellValue(knz.gettablename().doubleValue());}