Package inha.git.statistics.api.service

Class AbstractExcelService

java.lang.Object

inha.git.statistics.api.service.AbstractExcelService

All Implemented Interfaces:

StatisticsExcelService

Direct Known Subclasses:

PatentExcelService, ProjectExcelService, QuestionExcelService

public abstract class AbstractExcelService
extends Object
implements StatisticsExcelService

Constructor Summary

Constructors

Constructor	Description
AbstractExcelService()

Method Summary

Modifier and Type	Method	Description
protected void	createHeaders(org.apache.poi.ss.usermodel.Row headerRow, org.apache.poi.ss.usermodel.Workbook workbook)
protected org.apache.poi.ss.usermodel.CellStyle	createHeaderStyle(org.apache.poi.ss.usermodel.Workbook workbook)
void	exportToExcelFile(jakarta.servlet.http.HttpServletResponse response, StatisticsType statisticsType, Integer filterId, Integer semesterId)
protected abstract List<?>	getData(StatisticsType statisticsType, Integer filterId, Integer semesterId)
protected abstract String	getFileName()
protected abstract String[]	getHeaders()
protected abstract String	getSheetName()
protected void	setColumnWidths(org.apache.poi.ss.usermodel.Sheet sheet)
protected abstract void	writeData(org.apache.poi.ss.usermodel.Sheet sheet, List<?> data)
protected void	writeToResponse(org.apache.poi.ss.usermodel.Workbook workbook, jakarta.servlet.http.HttpServletResponse response)

Methods inherited from class java.lang.Object

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

Constructor Details

AbstractExcelService

public AbstractExcelService()

Method Details

exportToExcelFile

public void exportToExcelFile(jakarta.servlet.http.HttpServletResponse response,
 StatisticsType statisticsType,
 Integer filterId,
 Integer semesterId)

Specified by:

exportToExcelFile in interface StatisticsExcelService

createHeaders

protected void createHeaders(org.apache.poi.ss.usermodel.Row headerRow,
 org.apache.poi.ss.usermodel.Workbook workbook)

createHeaderStyle

protected org.apache.poi.ss.usermodel.CellStyle createHeaderStyle(org.apache.poi.ss.usermodel.Workbook workbook)

setColumnWidths

protected void setColumnWidths(org.apache.poi.ss.usermodel.Sheet sheet)

writeToResponse

protected void writeToResponse(org.apache.poi.ss.usermodel.Workbook workbook,
 jakarta.servlet.http.HttpServletResponse response)
                        throws IOException

Throws:

IOException

getSheetName

protected abstract String getSheetName()

getFileName

protected abstract String getFileName()

getHeaders

protected abstract String[] getHeaders()

getData

protected abstract List<?> getData(StatisticsType statisticsType,
 Integer filterId,
 Integer semesterId)

writeData

protected abstract void writeData(org.apache.poi.ss.usermodel.Sheet sheet,
 List<?> data)