|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectframework.util.ExcelUtil
public class ExcelUtil
Excel Ãâ·ÂÀ» À§ÇØ ÀÌ¿ëÇÒ ¼ö ÀÖ´Â À¯Æ¿¸®Æ¼ Ŭ·¡½ºÀÌ´Ù.
Method Summary | |
---|---|
static java.lang.String |
escapeSep(java.lang.String str,
java.lang.String sep)
±¸ºÐÀÚ·Î ¾²ÀÌ´Â ¹®ÀÚ¿ ¶Ç´Â °³Ç๮ÀÚ°¡ °ª¿¡ Æ÷ÇԵǾî ÀÖÀ» °æ¿ì °ªÀ» ½Öµû¿ÈÇ¥·Î µÑ·¯½Îµµ·Ï º¯È¯ÇÑ´Ù. |
static java.lang.String |
formatSep(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList,
java.lang.String sep)
List°´Ã¼¸¦ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. |
static java.lang.String |
formatSep(java.util.Map<java.lang.String,java.lang.Object> map,
java.lang.String sep)
Map°´Ã¼¸¦ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. |
static java.lang.String |
formatSep(RecordSet rs,
java.lang.String sep)
RecordSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. |
static java.lang.String |
formatSep(java.sql.ResultSet rs,
java.lang.String sep)
ResultSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. |
static java.util.List<java.util.Map<java.lang.String,java.lang.String>> |
parse(java.io.File file)
È®ÀåÀÚ¿¡ ÀÇÇØ¼ ¿¢¼¿ÆÄÀÏÀ» ÆÄ½ÌÇÑ´Ù. |
static java.util.List<java.util.Map<java.lang.String,java.lang.String>> |
parse(org.apache.commons.fileupload.FileItem fileItem)
È®ÀåÀÚ¿¡ ÀÇÇØ¼ ¿¢¼¿ÆÄÀÏÀ» ÆÄ½ÌÇÑ´Ù. |
static int |
setRecordSetCSV(javax.servlet.http.HttpServletResponse response,
RecordSet rs,
java.lang.String fileName)
RecordSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setRecordSetSep(javax.servlet.http.HttpServletResponse response,
RecordSet rs,
java.lang.String fileName,
java.lang.String sep)
RecordSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù. |
static int |
setRecordSetTSV(javax.servlet.http.HttpServletResponse response,
RecordSet rs,
java.lang.String fileName)
RecordSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setRecordSetXLS(javax.servlet.http.HttpServletResponse response,
RecordSet rs,
java.lang.String fileName)
RecordSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setRecordSetXLSX(javax.servlet.http.HttpServletResponse response,
RecordSet rs,
java.lang.String fileName)
RecordSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setResultSetCSV(javax.servlet.http.HttpServletResponse response,
java.sql.ResultSet rs,
java.lang.String fileName)
ResultSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setResultSetSep(javax.servlet.http.HttpServletResponse response,
java.sql.ResultSet rs,
java.lang.String fileName,
java.lang.String sep)
ResultSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù. |
static int |
setResultSetTSV(javax.servlet.http.HttpServletResponse response,
java.sql.ResultSet rs,
java.lang.String fileName)
ResultSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setResultSetXLS(javax.servlet.http.HttpServletResponse response,
java.sql.ResultSet rs,
java.lang.String fileName)
ResultSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
setResultSetXLSX(javax.servlet.http.HttpServletResponse response,
java.sql.ResultSet rs,
java.lang.String fileName)
ResultSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù. |
static int |
writeCSV(java.io.File file,
RecordSet rs)
RecordSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeCSV(java.io.File file,
java.sql.ResultSet rs)
ResultSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeSep(java.io.File file,
RecordSet rs,
java.lang.String sep)
RecordSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeSep(java.io.File file,
java.sql.ResultSet rs,
java.lang.String sep)
ResultSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeTSV(java.io.File file,
RecordSet rs)
RecordSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeTSV(java.io.File file,
java.sql.ResultSet rs)
ResultSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeXLS(java.io.File file,
RecordSet rs)
RecordSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeXLS(java.io.File file,
java.sql.ResultSet rs)
ResultSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeXLSX(java.io.File file,
RecordSet rs)
RecordSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
static int |
writeXLSX(java.io.File file,
java.sql.ResultSet rs)
ResultSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public static java.util.List<java.util.Map<java.lang.String,java.lang.String>> parse(org.apache.commons.fileupload.FileItem fileItem) throws java.lang.Exception
fileItem
- ÆÄÀϾÆÀÌÅÛ
java.lang.Exception
public static java.util.List<java.util.Map<java.lang.String,java.lang.String>> parse(java.io.File file) throws java.lang.Exception
file
- ÆÄÀÏ
java.lang.Exception
public static int setRecordSetXLS(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String fileName) throws ColumnNotFoundException, java.io.IOException
response
- rs
- fileName
-
ColumnNotFoundException
java.io.IOException
public static int writeXLS(java.io.File file, RecordSet rs) throws ColumnNotFoundException, java.io.IOException
file
- rs
-
ColumnNotFoundException
java.io.IOException
public static int setRecordSetXLSX(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String fileName) throws ColumnNotFoundException, java.io.IOException
response
- rs
- fileName
-
ColumnNotFoundException
java.io.IOException
public static int writeXLSX(java.io.File file, RecordSet rs) throws ColumnNotFoundException, java.io.IOException
file
- rs
-
ColumnNotFoundException
java.io.IOException
public static int setRecordSetCSV(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String fileName) throws ColumnNotFoundException, java.io.IOException
response
- rs
- fileName
-
ColumnNotFoundException
java.io.IOException
public static int writeCSV(java.io.File file, RecordSet rs) throws java.io.IOException, ColumnNotFoundException
file
- rs
-
java.io.IOException
ColumnNotFoundException
public static int setRecordSetTSV(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String fileName) throws ColumnNotFoundException, java.io.IOException
response
- rs
- fileName
-
ColumnNotFoundException
java.io.IOException
public static int writeTSV(java.io.File file, RecordSet rs) throws java.io.IOException, ColumnNotFoundException
file
- rs
-
java.io.IOException
ColumnNotFoundException
public static int setRecordSetSep(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String fileName, java.lang.String sep) throws ColumnNotFoundException, java.io.IOException
response
- Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼rs
- ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ RecordSet °´Ã¼fileName
- sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
ColumnNotFoundException
java.io.IOException
public static int writeSep(java.io.File file, RecordSet rs, java.lang.String sep) throws java.io.IOException, ColumnNotFoundException
file
- rs
- sep
-
java.io.IOException
ColumnNotFoundException
public static java.lang.String formatSep(RecordSet rs, java.lang.String sep) throws ColumnNotFoundException
rs
- º¯È¯ÇÒ RecordSet °´Ã¼sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
ColumnNotFoundException
public static int setResultSetXLS(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String fileName) throws java.sql.SQLException, java.io.IOException
response
- rs
- fileName
-
java.sql.SQLException
java.io.IOException
public static int writeXLS(java.io.File file, java.sql.ResultSet rs) throws java.sql.SQLException, java.io.IOException
file
- rs
-
java.sql.SQLException
java.io.IOException
public static int setResultSetXLSX(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String fileName) throws java.sql.SQLException, java.io.IOException
response
- rs
- fileName
-
java.sql.SQLException
java.io.IOException
public static int writeXLSX(java.io.File file, java.sql.ResultSet rs) throws java.sql.SQLException, java.io.IOException
file
- rs
-
java.sql.SQLException
java.io.IOException
public static int setResultSetCSV(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String fileName) throws java.sql.SQLException, java.io.IOException
response
- rs
- fileName
-
java.sql.SQLException
java.io.IOException
public static int writeCSV(java.io.File file, java.sql.ResultSet rs) throws java.io.IOException, java.sql.SQLException
file
- rs
-
java.io.IOException
java.sql.SQLException
public static int setResultSetTSV(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String fileName) throws java.sql.SQLException, java.io.IOException
response
- rs
- fileName
-
java.sql.SQLException
java.io.IOException
public static int writeTSV(java.io.File file, java.sql.ResultSet rs) throws java.io.IOException, java.sql.SQLException
file
- rs
-
java.io.IOException
java.sql.SQLException
public static int setResultSetSep(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String fileName, java.lang.String sep) throws java.sql.SQLException, java.io.IOException
response
- Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼rs
- ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.fileName
- sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
java.sql.SQLException
java.io.IOException
public static int writeSep(java.io.File file, java.sql.ResultSet rs, java.lang.String sep) throws java.io.IOException, java.sql.SQLException
file
- rs
- sep
-
java.io.IOException
java.sql.SQLException
public static java.lang.String formatSep(java.sql.ResultSet rs, java.lang.String sep) throws java.sql.SQLException
rs
- º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
java.sql.SQLException
public static java.lang.String formatSep(java.util.Map<java.lang.String,java.lang.Object> map, java.lang.String sep)
map
- º¯È¯ÇÒ Map°´Ã¼sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
public static java.lang.String formatSep(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList, java.lang.String sep)
mapList
- º¯È¯ÇÒ List°´Ã¼sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
public static java.lang.String escapeSep(java.lang.String str, java.lang.String sep)
str
- º¯È¯ÇÒ ¹®ÀÚ¿sep
- ¿ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |