Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to read data from CSV file in Java?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 2
    • 0
    • 2
    • 0
    • 0
    • 0
    • 0
    • 459
    Comment on it

    Sometimes we need to read data from a CSV file as per requirement. You can easily read the data from CSV file by following the below steps:

    1. Write the following Maven configuration in pom.xml file in your project:
    1. <dependency>
    2.     <groupid>net.sf.opencsv</groupid>
    3.     <artifactid>opencsv</artifactid>
    4.     <version>2.3</version>
    5. </dependency>
    1. Now define the model class in which you want to store data from CSV.
    1. public class TempModel
    2. {
    3.     private String customId;
    4.     private String tickitStatus;
    5.     private String tickitType;
    6.     private String tickitMsgBody;
    7.     private String tickitStringStartDate;
    8.     private String tickitStringEndDate;
    9.     public String getCustomId()
    10.     {
    11.         return customId;
    12.     }
    13.     public void setCustomId(String customId)
    14.     {
    15.         this.customId = customId;
    16.     }
    17.     public String getTickitStatus()
    18.     {
    19.         return tickitStatus;
    20.     }
    21.     public void setTickitStatus(String tickitStatus)
    22.     {
    23.         this.tickitStatus = tickitStatus;
    24.     }
    25.     public String getTickitType()
    26.     {
    27.         return tickitType;
    28.     }
    29.     public void setTickitType(String tickitType)
    30.     {
    31.         this.tickitType = tickitType;
    32.     }
    33.     public String getTickitMsgBody()
    34.     {
    35.         return tickitMsgBody;
    36.     }
    37.     public void setTickitMsgBody(String tickitMsgBody)
    38.     {
    39.         this.tickitMsgBody = tickitMsgBody;
    40.     }
    41.     public String getTickitStringStartDate()
    42.     {
    43.         return tickitStringStartDate;
    44.     }
    45.     public void setTickitStringStartDate(String tickitStringStartDate)
    46.     {
    47.         this.tickitStringStartDate = tickitStringStartDate;
    48.     }
    49.     public String getTickitStringEndDate()
    50.     {
    51.         return tickitStringEndDate;
    52.     }
    53.     public void setTickitStringEndDate(String tickitStringEndDate)
    54.     {
    55.         this.tickitStringEndDate = tickitStringEndDate;
    56.     }
    57.  
    58. }
    1. Now write the below method to read data from CSV file:
    1.  /**
    2.      * This methos is used to red data fro CSV file
    3.      * @param uploadedInputStream
    4.      */
    5.     public void readDataFromCSV(InputStream uploadedInputStream)
    6.     {
    7.         TicketModel ticketModel = null;
    8.         UserResponse userResponse = new UserResponse();
    9.  
    10.         try
    11.         {
    12.             ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy();
    13.             strat.setType(TempModel.class);
    14.             // The fields to bind do in your JavaBean
    15.             String[] columns = new String[] { "customId", "tickitStatus", "tickitType","tickitMsgBody", "tickitStringStartDate","tickitStringEndDate" };
    16.             strat.setColumnMapping(columns);
    17.             CsvToBean csv = new CsvToBean();
    18.  
    19.             CSVReader csvReader;
    20.             csvReader = new CSVReader(new InputStreamReader(uploadedInputStream), ',', '\"', 1);
    21.             List list = csv.parse(strat, csvReader);
    22.  
    23.             for (TempModel tempModel : list)
    24.             {
    25.                 logger.debug("After Read line");
    26.                 logger.debug(tempModel.getCustomId());
    27.             }
    28.  
    29.         }
    30.         catch (Exception e)
    31.         {
    32.             e.printStackTrace();
    33.             logger.error("failed", e);
    34.  
    35.         }
    36.         finally
    37.         {
    38.             if (uploadedInputStream != null)
    39.             {
    40.                 try
    41.                 {
    42.                     uploadedInputStream.close();
    43.                 }
    44.                 catch (IOException e)
    45.                 {
    46.                     e.printStackTrace();
    47.                 }
    48.             }
    49.  
    50.         }
    51.     }

    In the above example "readDataFromCSV" method will take CSV file as inputStream and read data from CSV file and store that data into list which is type of TempModel.

    Hope this will help you :)

    Java CSV OpenCSV read CSV
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: