public interface EgovExcelService
NOTE: 엑셀 서비스를 제공하기 위해 여러 기능들을 선언하는 인터페이스이다.
== 개정이력(Modification Information) == 수정일 수정자 수정내용 ------- -------- --------------------------- 2009.06.01 윤성종 최초 생성 2013.05.22 이기하 XSSF, SXSSF 형식 추가 2014.05.14 이기하 XSSF형식 구분자 추가 및 workbook으로 변경
| Modifier and Type | Method and Description |
|---|---|
org.apache.poi.ss.usermodel.Workbook |
createWorkbook(org.apache.poi.ss.usermodel.Workbook wb,
String filepath)
Workbook 객체를 생성하여 엑셀파일을 생성한다.
|
org.apache.poi.ss.usermodel.Workbook |
loadExcelTemplate(String templateName)
엑셀 Template를 로딩하여 엑셀파일을 생성한다.
|
org.apache.poi.xssf.usermodel.XSSFWorkbook |
loadExcelTemplate(String templateName,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀 Template를 로딩하여 엑셀파일을 생성한다.
|
org.apache.poi.ss.usermodel.Workbook |
loadWorkbook(InputStream fileIn)
엑셀 파일을 로딩한다.
|
org.apache.poi.xssf.usermodel.XSSFWorkbook |
loadWorkbook(InputStream fileIn,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀 파일을 로딩한다.
|
org.apache.poi.ss.usermodel.Workbook |
loadWorkbook(String filepath)
엑셀 파일을 로딩한다.
|
org.apache.poi.xssf.usermodel.XSSFWorkbook |
loadWorkbook(String filepath,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀 파일을 로딩한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn)
엑셀파일을 저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
int start,
long commitCnt,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlxs 엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
short sheetIndex,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
short sheetIndex,
int start,
long commitCnt,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
String sheetName,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
String sheetName,
int start,
long commitCnt,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀파일을 저장한다.
|
Integer |
uploadExcel(String queryId,
org.apache.poi.ss.usermodel.Sheet sheet,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
org.apache.poi.ss.usermodel.Workbook createWorkbook(org.apache.poi.ss.usermodel.Workbook wb,
String filepath)
throws Exception
wb - filepath - Exceptionorg.apache.poi.ss.usermodel.Workbook loadExcelTemplate(String templateName) throws Exception
templateName - Exceptionorg.apache.poi.xssf.usermodel.XSSFWorkbook loadExcelTemplate(String templateName, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
templateName - type - Exceptionorg.apache.poi.ss.usermodel.Workbook loadWorkbook(String filepath) throws Exception
filepath - Exceptionorg.apache.poi.xssf.usermodel.XSSFWorkbook loadWorkbook(String filepath, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
filepath - type - Exceptionorg.apache.poi.ss.usermodel.Workbook loadWorkbook(InputStream fileIn) throws Exception
fileIn - Exceptionorg.apache.poi.xssf.usermodel.XSSFWorkbook loadWorkbook(InputStream fileIn, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
fileIn - type - ExceptionInteger uploadExcel(String queryId, org.apache.poi.ss.usermodel.Sheet sheet, int start, long commitCnt) throws Exception
queryId - sheet - start - (default : 0)commitCnt - (default :0)ExceptionInteger uploadExcel(String queryId, InputStream fileIn, int start, long commitCnt) throws Exception
queryId - fileIn - start - (default : 0)commitCnt - (default : 0)ExceptionInteger uploadExcel(String queryId, InputStream fileIn, int start, long commitCnt, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
queryId - fileIn - start - commitCnt - type - ExceptionInteger uploadExcel(String queryId, InputStream fileIn) throws Exception
queryId - fileIn - ExceptionInteger uploadExcel(String queryId, InputStream fileIn, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
queryId - fileIn - ExceptionInteger uploadExcel(String queryId, InputStream fileIn, short sheetIndex, int start, long commitCnt) throws Exception
queryId - fileIn - sheetIndex - start - (default : 0)commitCnt - (default : 0)ExceptionInteger uploadExcel(String queryId, InputStream fileIn, short sheetIndex, int start, long commitCnt, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
queryId - fileIn - sheetIndex - start - (default : 0)commitCnt - (default : 0)type - ExceptionInteger uploadExcel(String queryId, InputStream fileIn, String sheetName, int start, long commitCnt) throws Exception
queryId - fileIn - sheetName - start - (default : 0)commitCnt - (default : 0)ExceptionInteger uploadExcel(String queryId, InputStream fileIn, String sheetName, int start, long commitCnt, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws Exception
queryId - fileIn - sheetName - start - (default : 0)commitCnt - (default : 0)type - ExceptionCopyright © 2015. All rights reserved.