2 Ways To Parse Csv Files Inwards Coffee - Bufferedreader Vs Apache

In terminal tutorial, you lot receive got learned how to parse Excel file inward Java too inward this Java tutorial, you lot volition larn how to parse CSV file inward Java. You tin straight parse CSV file inward Java without using whatsoever 3rd political party library, because ultimately its a text file too you lot tin occupation BufferedReader to read it, but you lot tin too accept wages of proficient opened upwardly root library similar Apache park CSV to parse comma separated values. These library makes developer's life slowly too provides rich functionality to parse diverse CSV formats. In existent programming world, CSV or comma separated files are used for multifariousness of purpose, including for transporting information from i organisation to unopen to other e.g. FX rates, importing too exporting records from database etc. In CSV files entries are separated yesteryear comma, too it may or may non comprise header. There are many ways to parse or read CSV files inward Java, too if you lot postulate to exercise it on your project, its ameliorate non to reinvent the cycle too take away park csv, but for learning purpose, it's proficient to know how to exercise it without using 3rd political party library.

In this tutorial, I am going to demonstrate you lot 2 ways to read CSV files inward Java. First means is yesteryear using java.io.BufferedReader too split() method from java.lang.String class, too minute means is yesteryear using Apache Commons CSV library's CSVParser class. Commons CSV is novel fellow member inward rich Apache park identify unit of measurement too has built inward back upwardly to read most mutual CSV formats e.g. RFC 4180, Microsoft Excel, MySQL too TDF. You tin too create custom format yesteryear using fluent manner API of Apache park CSV.  CSVParser is fully functional parser, which tin parse dissimilar form of CSV files e.g. XLS CSV file, CSV file without header or CSV file amongst header. All you lot postulate to exercise is to take away dissimilar format for CSVParser, which nosotros volition larn inward this tutorial. By the way, if you lot desire to larn to a greater extent than virtually reading/writing files inward Java, I advise to read i of the proficient Java mass similar Core Java yesteryear Cay S. Horstmann or Java: Influenza A virus subtype H5N1 Beginner's Guide yesteryear Herbert Schildt.

Maven dependency too JAR file required for CSV Parsing

In social club to occupation this library you lot postulate to add commons-csv-1.1.jar file into your classpath. If you lot are using Maven you lot tin too add together next dependency inward your projection file.

<dependency>     <groupId>org.apache.commons</groupId>     <artifactId>commons-csv</artifactId>     <version>1.1</version> </dependency>

Remember, its ameliorate to occupation Maven for managing dependency because it volition too download whatsoever other JAR file on which this library is dependent, known every bit transitive dependencies. If you lot add together JAR files manually, you lot brand certain to download whatsoever subject JAR.

CSV Parser to read CSV files inward Java

Apache Commons CSV reads too writes files inward variations of the Comma Separated Value (CSV) format. For representative to parse an Excel CSV file, you lot postulate to write next code

Reader inward = ...; Iterable parser = CSVFormat.EXCEL.parse(in); for (CSVRecord tape : parser) {     ... }

too to read a normal CSV file amongst header you lot postulate to write :

Reader inward = ...; Iterable parser = CSVFormat.DEFAULT.parse(in); for (CSVRecord tape : parser) {     ... }

Currently Apache park CSV supports next formats :

• DEFAULT to read measure comma separated format, every bit for RFC4180 but allowing empty lines.
• EXCEL to read Excel file format (both XLS too XLSX) (using a comma every bit the value delimiter).
• MYSQL to parse default MySQL format used yesteryear the SELECT INTO OUTFILE too LOAD DATA INFILE operations.
• RFC4180 to read comma separated format every bit defined yesteryear RFC 4180.
• TDF to parse tab-delimited format, amongst quote; leading too trailing spaces ignored

It's to a greater extent than functional, too should hold out used inward existent the world project. On the other manus BufferedReader approach is pretty straight forward. You opened upwardly a CSV file too start reading it trouble yesteryear line, since each trouble contains a coma separated String, you lot postulate to split upwardly them using comma (",") too you lot volition acquire an array of String containing each column. Just exercise whatever you lot wants to exercise amongst them, if you lot are creating object, every bit shown inward outset example, too thus create them, otherwise you lot tin exactly impress them similar inward minute example. You tin fifty-fifty occupation novel Java vii too Java 8 characteristic to read file to a greater extent than efficiently.

Java Program to Parse or Read CSV File inward Java

Here is total code representative of how to read CSV file inward Java. This programme contains 2 examples, outset i read CSV file without using 3rd political party library too the minute i parse file using Apache park CSV, a novel library for parsing CSV files. Make certain you lot include commons-csv-1.1.jar file inward your CLASSPATH to run this programme inward your PC.  Here is our sample CSV file, which too contains header too has contains countries exceptional e.g. mention of country, its majuscule too currency.

Our CSV file - countries.txt
NAME,CAPITAL,CURRENCY
India,New Delhi,INR
USA,Washington,USD
England,London,GBP
Japan,Tokyo,JPY

There are 2 methods inward this programme readCSV() too parseCSV(), erstwhile uses BufferedReader to read CSV file. We too receive got a degree Country to stand upwardly for each trouble of file, which basically contains province specific data. In outset method nosotros read the file trouble yesteryear trouble too then split upwardly each trouble on comma to acquire a String array containing private fields. We occupation this array to create Country object too add together them into the List, which is returned yesteryear our method. Code of this method is real straight frontward too self explanatory, nosotros receive got ignored the outset trouble because nosotros know its header.

Second method is interesting every bit it demonstrate how to occupation apache park csv library to read csv file. As I said, park csv supports several csv format straight too nosotros volition occupation CSVFormat.DEFAULT, which too supports header. Here you lot create an representative of CSVParser yesteryear passing it a FileInputStream, which points to your csv file too CSVFormat. This contains several CSVRecord from which you lot tin shout upwardly private fields.

import java.io.BufferedReader; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.IOException; import java.util.ArrayList; import java.util.List; import java.util.Scanner; import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVParser; import org.apache.commons.csv.CSVRecord;  /**  * Java Program to parse too read CSV file using traditional BufferedReader  * approach too yesteryear using to a greater extent than functional CSV parser from Apache Commons CSV  * library. Apache Commons CSV back upwardly dissimilar CSV format including default  * one, amongst or without header, reading EXCEL or XLS CSV file etc.  *  * @author  */ public class CSVReader {          private static class Country {         private String name;         private String capital;         private String currency;          public Country(String name, String capital, String currency) {             this.name = name;             this.capital = capital;             this.currency = currency;         }          public String name() {             return name;         };          public String capital() {             return capital;         }          public String currency() {             return currency;         }          @Override         public String toString() {             return "Country [name=" + mention + ", capital=" + majuscule                     + ", currency=" + currency + "]";         }     }      public static void main(String args[]) throws FileNotFoundException, IOException {         System.out.println("Reading from CSV file using BufferedReader too String Split");         List nations = readCSV();         print(nations);         System.out.println("Parsing CSV file using CSVParser of Apache park CSV");         parseCSV();      }      /*      * Java programme to read CVS file using BufferedReader too String split()      * method      */     public static List readCSV() throws FileNotFoundException, IOException {         List countries = new ArrayList<>();         BufferedReader br = new BufferedReader(new FileReader("countries.csv"));          String trouble = br.readLine(); // Reading header, Ignoring          while ((line = br.readLine()) != null && !line.isEmpty()) {             String[] fields = line.split(",");             String mention = fields[0];             String majuscule = fields[1];             String currency = fields[2];             Country land = new Country(name, capital, currency);             countries.add(nation);         }         br.close();         return countries;     }      /*      * Method to read CSV file using CSVParser from Apache Commons CSV      */     public static void parseCSV() throws FileNotFoundException, IOException {         CSVParser parser = new CSVParser(new FileReader("countries.csv"), CSVFormat.DEFAULT.withHeader());          for (CSVRecord tape : parser) {             System.out.printf("%s\t%s\t%s\n", record.get("NAME"),                     record.get("CAPITAL"), record.get("CURRENCY"));         }         parser.close();     }      public static void print(List countries) {         System.out.println("========================");         for (Country province : countries) {             System.out.println(country);         }         System.out.println("========================");     }  }  Output: Reading from CSV file using BufferedReader too String Split ======================== Country [name=India, capital=New Delhi, currency=INR] Country [name=USA, capital=Washington, currency=USD] Country [name=England, capital=London, currency=GBP] Country [name=Japan, capital=Tokyo, currency=JPY] ========================  Parsing CSV file using CSVParser of Apache park CSV India   New Delhi       INR USA     Washington      USD England London          GBP Japan   Tokyo           JPY

You tin run into output of our programme matches amongst content of our CSV file. So both of our approach is working properly.

That's all folks, Enjoy parsing CSV file amongst Apache park CSV parser. Another smashing utility opened upwardly root library from Apache. You tin too written report whatsoever upshot flora spell using them. Influenza A virus subtype H5N1 overnice means to back upwardly opened upwardly root projects. I advise to occupation this library if you lot receive got to procedure CSV files inward your projection because its tried too tested too rich inward functionality. You tin occupation this library to charge CSV information into MySQL database or exactly create objects from them.

Further Learning
Complete Java Masterclass
guide)

How to convert JSON to Object inward Java? (example)

How to read XML file inward Java using JDOM parser? (tutorial)

How to parse large JSON file using Jackson Streaming API? (example)

How to read a file inward i trouble inward Java 8? (example) 

How to re-create File inward Java? (example)

How to generate MD5 checksum for file inward Java? (solution)

How to read/write RandomAccessFile inward Java? (example)

Bagikan Artikel ini