framework.util
Class ExcelUtil

java.lang.Object
  extended by framework.util.ExcelUtil

public class ExcelUtil
extends java.lang.Object

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

parse

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
È®ÀåÀÚ¿¡ ÀÇÇØ¼­ ¿¢¼¿ÆÄÀÏÀ» ÆÄ½ÌÇÑ´Ù.

Parameters:
fileItem - ÆÄÀϾÆÀÌÅÛ
Returns:
µ¥ÀÌÅÍÀÇ ¸®½ºÆ®
Throws:
java.lang.Exception

parse

public static java.util.List<java.util.Map<java.lang.String,java.lang.String>> parse(java.io.File file)
                                                                              throws java.lang.Exception
È®ÀåÀÚ¿¡ ÀÇÇØ¼­ ¿¢¼¿ÆÄÀÏÀ» ÆÄ½ÌÇÑ´Ù.

Parameters:
file - ÆÄÀÏ
Returns:
µ¥ÀÌÅÍÀÇ ¸®½ºÆ®
Throws:
java.lang.Exception

setRecordSetXLS

public static int setRecordSetXLS(javax.servlet.http.HttpServletResponse response,
                                  RecordSet rs,
                                  java.lang.String fileName)
                           throws ColumnNotFoundException,
                                  java.io.IOException
RecordSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

writeXLS

public static int writeXLS(java.io.File file,
                           RecordSet rs)
                    throws ColumnNotFoundException,
                           java.io.IOException
RecordSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

setRecordSetXLSX

public static int setRecordSetXLSX(javax.servlet.http.HttpServletResponse response,
                                   RecordSet rs,
                                   java.lang.String fileName)
                            throws ColumnNotFoundException,
                                   java.io.IOException
RecordSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

writeXLSX

public static int writeXLSX(java.io.File file,
                            RecordSet rs)
                     throws ColumnNotFoundException,
                            java.io.IOException
RecordSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

setRecordSetCSV

public static int setRecordSetCSV(javax.servlet.http.HttpServletResponse response,
                                  RecordSet rs,
                                  java.lang.String fileName)
                           throws ColumnNotFoundException,
                                  java.io.IOException
RecordSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

writeCSV

public static int writeCSV(java.io.File file,
                           RecordSet rs)
                    throws java.io.IOException,
                           ColumnNotFoundException
RecordSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
java.io.IOException
ColumnNotFoundException

setRecordSetTSV

public static int setRecordSetTSV(javax.servlet.http.HttpServletResponse response,
                                  RecordSet rs,
                                  java.lang.String fileName)
                           throws ColumnNotFoundException,
                                  java.io.IOException
RecordSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

writeTSV

public static int writeTSV(java.io.File file,
                           RecordSet rs)
                    throws java.io.IOException,
                           ColumnNotFoundException
RecordSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
java.io.IOException
ColumnNotFoundException

setRecordSetSep

public static int setRecordSetSep(javax.servlet.http.HttpServletResponse response,
                                  RecordSet rs,
                                  java.lang.String fileName,
                                  java.lang.String sep)
                           throws ColumnNotFoundException,
                                  java.io.IOException
RecordSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
ex) response·Î rs¸¦ ¿­±¸ºÐÀÚ ÄÞ¸¶(,) ÀÎ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => ExcelUtil.setRecordSetSep(response, rs, ",")

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ RecordSet °´Ã¼
fileName -
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

writeSep

public static int writeSep(java.io.File file,
                           RecordSet rs,
                           java.lang.String sep)
                    throws java.io.IOException,
                           ColumnNotFoundException
RecordSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
sep -
Returns:
󸮰Ǽö
Throws:
java.io.IOException
ColumnNotFoundException

formatSep

public static java.lang.String formatSep(RecordSet rs,
                                         java.lang.String sep)
                                  throws ColumnNotFoundException
RecordSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ ¿­±¸ºÐÀÚ ÄÞ¸¶(,) ÀÎ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String csv = ExcelUtil.formatSep(rs, ",")

Parameters:
rs - º¯È¯ÇÒ RecordSet °´Ã¼
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
ColumnNotFoundException

setResultSetXLS

public static int setResultSetXLS(javax.servlet.http.HttpServletResponse response,
                                  java.sql.ResultSet rs,
                                  java.lang.String fileName)
                           throws java.sql.SQLException,
                                  java.io.IOException
ResultSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

writeXLS

public static int writeXLS(java.io.File file,
                           java.sql.ResultSet rs)
                    throws java.sql.SQLException,
                           java.io.IOException
ResultSetÀ» ¿¢¼¿2003 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

setResultSetXLSX

public static int setResultSetXLSX(javax.servlet.http.HttpServletResponse response,
                                   java.sql.ResultSet rs,
                                   java.lang.String fileName)
                            throws java.sql.SQLException,
                                   java.io.IOException
ResultSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

writeXLSX

public static int writeXLSX(java.io.File file,
                            java.sql.ResultSet rs)
                     throws java.sql.SQLException,
                            java.io.IOException
ResultSetÀ» ¿¢¼¿2007 Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

setResultSetCSV

public static int setResultSetCSV(javax.servlet.http.HttpServletResponse response,
                                  java.sql.ResultSet rs,
                                  java.lang.String fileName)
                           throws java.sql.SQLException,
                                  java.io.IOException
ResultSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

writeCSV

public static int writeCSV(java.io.File file,
                           java.sql.ResultSet rs)
                    throws java.io.IOException,
                           java.sql.SQLException
ResultSetÀ» CSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
java.io.IOException
java.sql.SQLException

setResultSetTSV

public static int setResultSetTSV(javax.servlet.http.HttpServletResponse response,
                                  java.sql.ResultSet rs,
                                  java.lang.String fileName)
                           throws java.sql.SQLException,
                                  java.io.IOException
ResultSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÀÀ´ä°´Ã¼·Î Àü¼ÛÇÑ´Ù.

Parameters:
response -
rs -
fileName -
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

writeTSV

public static int writeTSV(java.io.File file,
                           java.sql.ResultSet rs)
                    throws java.io.IOException,
                           java.sql.SQLException
ResultSetÀ» TSV Çü½ÄÀ¸·Î º¯È¯ÇÏ¿© ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
Returns:
󸮰Ǽö
Throws:
java.io.IOException
java.sql.SQLException

setResultSetSep

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
ResultSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
ex) response·Î rs¸¦ ¿­±¸ºÐÀÚ ÄÞ¸¶(,) ÀÎ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => ExcelUtil.setResultSetSep(response, rs, ",")

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.
fileName -
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

writeSep

public static int writeSep(java.io.File file,
                           java.sql.ResultSet rs,
                           java.lang.String sep)
                    throws java.io.IOException,
                           java.sql.SQLException
ResultSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î ÆÄÀÏ·Î ÀúÀåÇÑ´Ù.

Parameters:
file -
rs -
sep -
Returns:
󸮰Ǽö
Throws:
java.io.IOException
java.sql.SQLException

formatSep

public static java.lang.String formatSep(java.sql.ResultSet rs,
                                         java.lang.String sep)
                                  throws java.sql.SQLException
ResultSetÀ» ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ ¿­±¸ºÐÀÚ ÄÞ¸¶(,) ÀÎ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String csv = ExcelUtil.formatSep(rs, ",")

Parameters:
rs - º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
java.sql.SQLException

formatSep

public static java.lang.String formatSep(java.util.Map<java.lang.String,java.lang.Object> map,
                                         java.lang.String sep)
Map°´Ã¼¸¦ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) mapÀ» ¿­±¸ºÐÀÚ ÄÞ¸¶(,) ÀÎ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String csv = ExcelUtil.formatSep(map, ",")

Parameters:
map - º¯È¯ÇÒ Map°´Ã¼
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­

formatSep

public 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 µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex1) mapList¸¦ ¿­±¸ºÐÀÚ ÄÞ¸¶(,) ÀÎ ±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String csv = ExcelUtil.formatSep(mapList, ",")

Parameters:
mapList - º¯È¯ÇÒ List°´Ã¼
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
±¸ºÐÀÚ(CSV, TSV µî)ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­

escapeSep

public static java.lang.String escapeSep(java.lang.String str,
                                         java.lang.String sep)
±¸ºÐÀÚ·Î ¾²ÀÌ´Â ¹®ÀÚ¿­ ¶Ç´Â °³Ç๮ÀÚ°¡ °ª¿¡ Æ÷ÇԵǾî ÀÖÀ» °æ¿ì °ªÀ» ½Öµû¿ÈÇ¥·Î µÑ·¯½Îµµ·Ï º¯È¯ÇÑ´Ù.

Parameters:
str - º¯È¯ÇÒ ¹®ÀÚ¿­
sep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­