1. Using Microsoft Excel<\/h4>\n
1:<\/strong> Open Microsoft Excel.<\/p>\n 2:<\/strong> Write the data into the excel file:<\/p>\n 3:<\/strong> Save the excel file with .csv extension as shown below:<\/p>\n We can also create a CSV file using Notepad with the following steps:<\/p>\n Step 1:<\/strong> Open Notepad editor.<\/p>\n Step 2:<\/strong> Write some data into file separated by comma (,).<\/p>\n For example: Step 3:<\/strong> Save the file with .csv extension. There are the following four ways to read a CSV file in Java:<\/p>\n The Scanner class of Java provides various methods by which we can read a CSV file. It provides a constructor that produces values scanned from the specified CSV file. This class also breaks the data in the form of tokens.<\/p>\n There is a delimiter pattern, which, by default, matches white space. Then, using different types of next() methods, we can convert the resulting tokens.<\/p>\n Code to read a CSV file using a Scanner class:<\/strong><\/p>\n Output:<\/strong><\/p>\n The String.split() of Java identifies the delimiter and split the rows into tokens.<\/p>\n The Syntax of this method is:<\/strong><\/p>\n Code to read a CSV file using String.split() method:<\/strong><\/p>\n Output:<\/strong><\/p>\n Output:<\/strong><\/p>\n OpenCSV API is a third party API. This API provides standard libraries to read various versions of the CSV file. The OpenCSV API also offers better control to handle the CSV files. This library can also read Tab-Delimited File or TDF file format.<\/p>\n We use the CSVReader class to read a CSV file. The class CSVReader provides a constructor to parse a CSV file.<\/p>\n Steps to read Java CSV file in eclipse:<\/strong><\/p>\n 1:<\/strong> Create a class file with the name CSVReaderDemo and write the following code. Code to read a CSV file using OpenCSV API:<\/strong><\/p>\n Output:<\/strong><\/p>\n![\"create](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2020\/06\/pasted-image-0-20.png\")
<\/a><\/p>\n<\/a><\/p>\n2. Using Notepad<\/h4>\n
\nRajat, Jain, 26, 999967439, Delhi<\/strong><\/p>\n
\nWe have created the following file.<\/p>\n<\/a><\/p>\nWays to read CSV file in Java<\/h3>\n
<\/a><\/p>\n1. Java Scanner class<\/h4>\n
import java.io. * ;\nimport java.util.Scanner;\npublic class CSVReaderDemo {\n public static void main(String[] args) throws Exception {\n Scanner sc = new Scanner(new File(\"C:\\\\Users\\\\Dell\\\\Desktop\\\\csvDemo.csv\"));\n \/\/parsing a CSV file into the constructor of Scanner class \n sc.useDelimiter(\",\");\n \/\/setting comma as delimiter pattern\n while (sc.hasNext()) {\n System.out.print(sc.next());\n }\n sc.close();\n \/\/closes the scanner \n }\n}<\/pre>\n
\nMr., Joseph, Patil, 4645968519, Hoogly
\nMr., Andrew, Mukherjee, 9067215139, Burmingham
\nMr., Varun, Patel, 2503595381, Sindh
\nMr., Michael, Baldwin, 7631068844, Kentucky
\nMr., Emmanuel, Agarwal, 3538037535, Nice
\nMr., Sumeet, Patil, 6871075256, Aukland
\nMr., Pranab, Kulkarni, 7982264359, Hubli
\nMr., Rajeev, Singh, 3258837884, Patiala
\nMr., Sujay, Kapoor, 5127263160, Mumbai<\/div>\n2. Java String.split() method<\/h4>\n
public String[] split(String regex)<\/pre>\n
import java.io. * ;\npublic class CSVReader {\n public static final String delimiter = \",\";\n public static void read(String csvFile) {\n try {\n File file = new File(csvFile);\n FileReader fr = new FileReader(file);\n BufferedReader br = new BufferedReader(fr);\n String line = \" \";\n String[] tempArr;\n while ((line = br.readLine()) != null) {\n tempArr = line.split(delimiter);\n for (String tempStr: tempArr) {\n System.out.print(tempStr + \" \");\n }\n System.out.println();\n }\n br.close();\n }\n catch(IOException ioe) {\n ioe.printStackTrace();\n }\n }\n public static void main(String[] args) {\n \/\/csv file to read\n String csvFile = \"C:\\\\Users\\\\Dell\\\\Desktop\\\\csvDemo.csv\";\n CSVReader.read(csvFile);\n }\n}<\/pre>\n
\nMr., Joseph, Patil, 4645968519, Hoogly
\nMr., Andrew, Mukherjee, 9067215139, Burmingham
\nMr., Varun, Patel, 2503595381, Sindh
\nMr., Michael, Baldwin, 7631068844, Kentucky
\nMr., Emmanuel, Agarwal, 3538037535, Nice
\nMr., Sumeet, Patil, 6871075256, Aukland
\nMr., Pranab, Kulkarni, 7982264359, Hubli
\nMr., Rajeev, Singh, 3258837884, Patiala
\nMr., Sujay, Kapoor, 5127263160, Mumbai<\/div>\n3. Using BufferedReader class in Java<\/h4>\n
import java.io.BufferedReader;\nimport java.io.FileReader;\nimport java.io.IOException;\npublic class CSV {\n public static void main(String[] args) {\n String line = \"\";\n String splitBy = \",\";\n try {\n \/\/parsing a CSV file into BufferedReader class constructor \n BufferedReader br = new BufferedReader(new FileReader(\"C:\\\\Users\\\\Dell\\\\Desktop\\\\csvDemo.csv\"));\n while ((line = br.readLine()) != null)\n \/\/returns a Boolean value \n {\n String[] employee = line.split(splitBy);\n \/\/use comma as separator \n System.out.println(\"Emp[First Name=\" + employee[1] + \", Last Name=\" + employee[2] + \", Contact=\" + employee[3] + \", City= \" + employee[4] + \"]\");\n }\n }\n catch(IOException e) {\n e.printStackTrace();\n }\n }\n}<\/pre>\n
\nEmp[First Name=Joseph, Last Name=Patil, Contact= 4645968519, City= Hoogly]
\nEmp[First Name=Andrew, Last Name=Mukherjee, Contact= 9067215139, City= Burmingham]
\nEmp[First Name=Varun, Last Name=Patel, Contact= 2503595381, City= Sindh]
\nEmp[First Name=Michael, Last Name=Baldwin, Contact= 7631068844, City= Kentucky]
\nEmp[First Name=Emmanuel, Last Name=Agarwal, Contact= 3538037535, City= Nice]
\nEmp[First Name=Sumeet, Last Name=Patil, Contact= 6871075256, City= Aukland]
\nEmp[First Name=Pranab, Last Name=Kulkarni, Contact= 7982264359, City= Hubli]
\nEmp[First Name=Rajeev, Last Name=Singh, Contact= 3258837884, City= Patiala]
\nEmp[First Name=Sujay, Last Name=Kapoor, Contact= 5127263160, City= Mumbai]<\/div>\n4. Using OpenCSV API in Java<\/h4>\n
Features of Java OpenCSV API<\/h4>\n
\n
\n2:<\/strong> Create a lib folder in the project.
\n3:<\/strong> Download opencsv-3.8.jar<\/a>
\n4:<\/strong> Copy the opencsv-3.8.jar and paste into the lib folder.
\n5:<\/strong> Run the program.<\/p>\nimport java.io.FileReader;\nimport com.opencsv.CSVReader;\npublic class CSVReaderDemo {\n public static void main(String[] args) {\n CSVReader reader = null;\n try {\n \/\/parsing a CSV file into CSVReader class constructor \n reader = new CSVReader(new FileReader(\"C:\\\\Users\\Dell\\Desktop\\csvDemo.csv\"));\n String[] nextLine;\n \/\/reads one line at a time \n while ((nextLine = reader.readNext()) != null) {\n for (String token: nextLine) {\n System.out.print(token);\n }\n System.out.print(\"\\n\");\n }\n }\n catch(Exception e) {\n e.printStackTrace();\n }\n }\n}<\/pre>\n