read CSV File - Java File Path IO

Java examples for File Path IO:CSV File

  1. HOME
  2. Java
  3. File Path IO
  4. CSV File

Description

read CSV File

Demo Code


//package com.java2s;
import java.io.BufferedReader;

import java.io.FileInputStream;

import java.io.IOException;
import java.io.InputStreamReader;

import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class Main {

    public static List<List<String>> readCSVFile(String f,
            String charsetName) {
        InputStreamReader fr = null;
        BufferedReader br = null;

        String rec = null;// 
        String str;// ?
        List<List<String>> listFile = new ArrayList<List<String>>();
        try {//from   ww w  .j  av  a  2  s  . co  m
            fr = new InputStreamReader(new FileInputStream(f), charsetName);
            br = new BufferedReader(fr);
            // 
            while ((rec = br.readLine()) != null) {
                rec += ",";
                Pattern pCells = Pattern
                        .compile("(\"[^\"]*(\"{2})*[^\"]*\")*[^,]*,");
                Matcher mCells = pCells.matcher(rec);
                List<String> cells = new ArrayList<String>();// ?list
                // 
                while (mCells.find()) {
                    str = mCells.group();
                    str = str.replaceAll(
                            "(?sm)\"?([^\"]*(\"{2})*[^\"]*)\"?.*,", "$1");
                    str = str.replaceAll("(?sm)(\"(\"))", "$2");
                    cells.add(str);
                }
                listFile.add(cells);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (fr != null) {
                try {
                    fr.close();
                } catch (IOException e) {
                }
            }
            if (br != null) {
                try {
                    br.close();
                } catch (IOException e) {
                }
            }
        }

        System.out.println(String.format("%s?", listFile.size()));
        return listFile;
    }
}

Related Tutorials