java 解析csv文件

<!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
 * @author panhf2003
 * @version 2008/09/05,
 */

public class CsvFileUtil
{
    
    /**
     * 构造，禁止实例化
     */
    private CsvFileUtil()
    {}
    
    public static void main(String[] args)
    {
        try
        {
            readCsvFile("d:\\ZD_CUSTOMER_VIEW.csv");
        }
        catch (FileNotFoundException ex)
        {
            Logger.getLogger(CsvFileUtil.class.getName()).log(Level.SEVERE,
                    null, ex);
        }
        catch (IOException ex)
        {
            Logger.getLogger(CsvFileUtil.class.getName()).log(Level.SEVERE,
                    null, ex);
        }
    }
    
    /**
     * csv文件读取<BR/> 读取绝对路径为argPath的csv文件数据，并以List返回。
     * 
     * @param argPath
     *            csv文件绝对路径
     * @return csv文件数据（List<String[]>）
     * @throws FileNotFoundException
     * @throws IOException
     */
    public static List<String[]> readCsvFile(String argPath)
            throws FileNotFoundException, IOException
    {
        CsvFileUtil util = new CsvFileUtil();
        File cvsFile = new File(argPath);
        List<String[]> list = new ArrayList<String[]>();
        FileReader fileReader = null;
        BufferedReader bufferedReader = null;
        try
        {
            fileReader = new FileReader(cvsFile);
            bufferedReader = new BufferedReader(fileReader);
            String regExp = util.getRegExp();
            
            String strLine = "";
            String str = "";
            while ((strLine = bufferedReader.readLine()) != null)
            {
                Pattern pattern = Pattern.compile(regExp);
                Matcher matcher = pattern.matcher(strLine);
                List<String> listTemp = new ArrayList<String>();
                while (matcher.find())
                {
                    str = matcher.group();
                    str = str.trim();
                    if (str.endsWith(","))
                    {
                        str = str.substring(0, str.length() - 1);
                        str = str.trim();
                    }
                    if (str.startsWith("\"") && str.endsWith("\""))
                    {
                        str = str.substring(1, str.length() - 1);
                        if (util.isExisted("\"\"", str))
                        {
                            str = str.replaceAll("\"\"", "\"");
                        }
                    }
                    if (!"".equals(str))
                    {
                        System.out.print(str + " ");
                        listTemp.add(str);
                    }
                }
                // test
                System.out.println();
                list.add((String[]) listTemp
                        .toArray(new String[listTemp.size()]));
            }
        }
        catch (FileNotFoundException e)
        {
            throw e;
        }
        catch (IOException e)
        {
            throw e;
        }
        finally
        {
            try
            {
                if (bufferedReader != null)
                {
                    bufferedReader.close();
                }
                if (fileReader != null)
                {
                    fileReader.close();
                }
            }
            catch (IOException e)
            {
                throw e;
            }
        }
        return list;
    }
    
    /**
     * csv文件做成<BR/> 将argList写入argPath路径下的argFileName文件里。
     * 
     * @param argList
     *            要写入csv文件的数据（List<String[]>）
     * @param argPath
     *            csv文件路径
     * @param argFileName
     *            csv文件名
     * @param isNewFile
     *            是否覆盖原有文件
     * @throws IOException
     * @throws Exception
     */
    public static void writeCsvFile(List<String[]> argList, String argPath,
            String argFileName, boolean isNewFile) throws IOException,
            Exception
    {
        CsvFileUtil util = new CsvFileUtil();
        // 数据check
        if (argList == null || argList.size() == 0)
        {
            throw new Exception("没有数据");
        }
        for (int i = 0; i < argList.size(); i++)
        {
            if (!(argList.get(i) instanceof String[]))
            {
                throw new Exception("数据格式不对");
            }
        }
        FileWriter fileWriter = null;
        BufferedWriter bufferedWriter = null;
        String strFullFileName = argPath;
        if (strFullFileName.lastIndexOf("\\") == (strFullFileName.length() - 1))
        {
            strFullFileName += argFileName;
        }
        else
        {
            strFullFileName += "\\" + argFileName;
        }
        File file = new File(strFullFileName);
        // 文件路径check
        if (!file.getParentFile().exists())
        {
            file.getParentFile().mkdirs();
        }
        try
        {
            if (isNewFile)
            {
                // 覆盖原有文件
                fileWriter = new FileWriter(file);
            }
            else
            {
                // 在原有文件上追加数据
                fileWriter = new FileWriter(file, true);
            }
            bufferedWriter = new BufferedWriter(fileWriter);
            for (int i = 0; i < argList.size(); i++)
            {
                String[] strTemp = (String[]) argList.get(i);
                for (int j = 0; j < strTemp.length; j++)
                {
                    if (util.isExisted("\"", strTemp[j]))
                    {
                        strTemp[j] = strTemp[j].replaceAll("\"", "\"\"");
                        bufferedWriter.write("\"" + strTemp[j] + "\"");
                    }
                    else if (util.isExisted(",", strTemp[j])
                            || util.isExisted("\n", strTemp[j])
                            || util.isExisted(" ", strTemp[j])
                            || util.isExisted("??", strTemp[j]))
                    {
                        bufferedWriter.write("\"" + strTemp[j] + "\"");
                    }
                    else
                    {
                        bufferedWriter.write(strTemp[j]);
                    }
                    if (j < strTemp.length - 1)
                    {
                        bufferedWriter.write(",");
                    }
                }
                bufferedWriter.newLine();
            }
        }
        catch (IOException e)
        {
            e.printStackTrace();
        }
        finally
        {
            try
            {
                if (bufferedWriter != null)
                {
                    bufferedWriter.close();
                }
                if (fileWriter != null)
                {
                    fileWriter.close();
                }
            }
            catch (IOException e)
            {
                throw e;
            }
        }
    }
    
    /**
     * @param argChar
     * @param argStr
     * @return
     */
    private boolean isExisted(String argChar, String argStr)
    {
        
        boolean blnReturnValue = false;
        if ((argStr.indexOf(argChar) >= 0)
                && (argStr.indexOf(argChar) <= argStr.length()))
        {
            blnReturnValue = true;
        }
        return blnReturnValue;
    }
    
    /**
     * 正则表达式。
     * 
     * @return 匹配csv文件里最小单位的正则表达式。
     */
    private String getRegExp()
    {
        StringBuffer strRegExps = new StringBuffer();
        strRegExps.append("\"((");
        strRegExps.append(SPECIAL_CHAR_A);
        strRegExps.append("*[,\\n 　])*(");
        strRegExps.append(SPECIAL_CHAR_A);
        strRegExps.append("*\"{2})*)*");
        strRegExps.append(SPECIAL_CHAR_A);
        strRegExps.append("*\"[ 　]*,[ 　]*");
        strRegExps.append("|");
        strRegExps.append(SPECIAL_CHAR_B);
        strRegExps.append("*[ 　]*,[ 　]*");
        strRegExps.append("|\"((");
        strRegExps.append(SPECIAL_CHAR_A);
        strRegExps.append("*[,\\n 　])*(");
        strRegExps.append(SPECIAL_CHAR_A);
        strRegExps.append("*\"{2})*)*");
        strRegExps.append(SPECIAL_CHAR_A);
        strRegExps.append("*\"[ 　]*");
        strRegExps.append("|");
        strRegExps.append(SPECIAL_CHAR_B);
        strRegExps.append("*[ 　]*");
        return strRegExps.toString();
    }
    
    private static final String SPECIAL_CHAR_A = "[^\",\\n 　]";
    
    private static final String SPECIAL_CHAR_B = "[^\",\\n]";
}

评论

1 楼 dubaopeng 2013-11-19  

挺好的，拿去改改！