Skip first line while reading CSVfile in Java

Question

While reading a CSV file, I need to ignore the first line. First row has date and heading of the CSV which I don't need to read.

I have to read only from the second row onward. Can anyone please help me?

String csvFilename = "C:\\Data\\csv_files\\REPORT.csv";
String filterCSV = "C:\\Data\\csv_files\\Output.csv";
CSVWriter write = new CSVWriter(new FileWriter(filterCSV));
CSVReader csvR = new CSVReader(new FileReader(csvFilename)); ---- 
List<CSVData> list = csv.parse(col, csvR);

for (Object object : list) {
    ------
}

Pete B. · Accepted Answer · 2014-01-08 14:49:33Z

3

Pretty simple:

 List<CSVData> list = csv.parse(col, csvR);
 list.remove(0);

answered Jan 8, 2014 at 14:49

Pete B.

3,3066 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lukas Warsitz · Accepted Answer · 2014-01-08 14:48:22Z

2

If you didnt write the CSVReader class by yourself then this constructor will skip the first line of the file:

CSVReader reader = new CSVReader(new FileReader(file), ',', '\'', 1);

answered Jan 8, 2014 at 14:48

Lukas Warsitz

1,2391 gold badge11 silver badges20 bronze badges

2 Comments

selson Over a year ago

I will try these options and let you know the results. thanks for the help

selson Over a year ago

CSVReader reader = new CSVReader(new FileReader(file), ',', '\'', 1); - this worked as expected. Can you please explain what is '\'' means? ================================================================= I have also tried to use list.remove(0). But it gives empty csv as output. for (Object object : list) { CSVData csvdataBean = (CSVData) object; System.out.println("inside List object" + csvdataBean.getTransferDate()); =----- It returns null value when I use list.remove(0) } Thanks

chopss · Accepted Answer · 2014-12-02 08:16:16Z

2

Before reading the entire data in a while loop using BufferedReader use br.readLine() then first line of csv file will be eliminated, then read the remaining contents using readLine() function.

    BufferedReader br = new BufferedReader(new FileReader("file.csv"));
    String line = " ";
    br.readLine();
    while((line=br.readLine())!=null)
    {
        System.out.println(line);
    }

answered Dec 2, 2014 at 8:16

chopss

81111 silver badges20 bronze badges

Comments

Greeshma Rayakar · Accepted Answer · 2020-11-26 12:54:06Z

0

You can also use the methods in CSVParser.java

BufferedReader br = new BufferedReader(new FileReader("file.csv"));
CSVParser csvParser = new CSVParser(reader, 
CSVFormat.DEFAULT.withHeader("firstColHeader","secondColHeader").withFirstRecordAsHeader().withTrim());

answered Nov 26, 2020 at 12:54

Greeshma Rayakar

1

Comments

Alexander Milosh · Accepted Answer · 2024-02-21 18:26:02Z

You can use skip(int numberOfLinesToSkip) method from CSVReader class.

users.csv:

firstName,lastName
Edward,Norton
Brad,Pitt

My Spring Boot example:

implementation "com.opencsv:opencsv:$openCsvVersion"

import com.opencsv.CSVReader;

    @Value("${users.csv.file.name}")
    private String usersCsvFileName;

    public void fillUsersFromCsv() {
        List<User> users = new ArrayList<>();

        var resource = resourceLoader.getResource("classpath:csv/" + usersCsvFileName);

        try (var inputStream = resource.getInputStream();
             var inputStreamReader = new InputStreamReader(inputStream);
             var csvReader = new CSVReader(inputStreamReader)) {
            csvReader.skip(1);

            String[] nextRecord;
            while ((nextRecord = csvReader.readNext()) != null) {
                var firstName = nextRecord[0];
                var lastName = nextRecord[1];

                var user = User.builder()
                    .firstName(firstName)
                    .lastName(lastName)
                    .build();
                users.add(user);
            }

        } catch (Exception e) {
            log.error("Failed to read users from usersCsvFileName file: {}", e.getMessage());
        }

        userRepository.saveAll(users);
        log.error("{} users from usersCsvFileName successfully saved to DB", users.size());
    }

JoSSte · Accepted Answer · 2020-03-19 12:20:20Z

-1

First, you have to add into List like ArrayList and then remove index[0] like this:

list.remove(0);

edited Mar 19, 2020 at 12:20

JoSSte

3,4427 gold badges43 silver badges63 bronze badges

answered Mar 19, 2020 at 10:57

Adnan Mahida

473 silver badges8 bronze badges

1 Comment

DaveyDaveDave Over a year ago

Welcome to StackOverflow! This answer is just repeating the same thing that Pete B.'s answer above says.

Collectives™ on Stack Overflow

Skip first line while reading CSVfile in Java

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related