Built-in method to count number of lines in a CSV file?

Question

user
u1
Khulbe
Sharma
gupta

These are the entries in the CSV file i want to know if there is a Java inbuilt function that can directly give me the number of lines in CSV file? In this case, it would be 5 lines.

Probably your best bet is to read the file and count the number of newline chars — Michael Goldstein, Nov 20 '14 at 07:32
You can find several solutions there ; http://stackoverflow.com/q/453018/1140748 — alain.janinm, Nov 20 '14 at 07:35
@Micheal Yea I have done that olready,i am new to java so thinking may be there could be a function also like we have count in case of PHP. — ankit, Nov 20 '14 at 07:36

score 4 · Answer 1 · answered Nov 20 '14 at 09:07

A built-in functionality would be to open the file and read how many lines there are. In Java8 for example, it would look like this:

final Path path = Paths.get(ClassLoader.getSystemResource("your.csv").toURI());
return Files.lines(path).skip(1L).count(); // skip(1L) to ignore the titles

score 2 · Answer 2 · answered Nov 20 '14 at 08:46

2

CSV has nothing to do with it. All you need is a line count. This can be accomplished in two lines of code with a LineNumberReader:

lineNumberReader.skip(Long.MAX_VALUE);
int lines = lineNumberReader.getLineNumber();

answered Nov 20 '14 at 08:46

user207421

305,947
44
307
483

score 0 · Answer 3 · edited Nov 20 '14 at 08:39

0

Super CSV. Have a close look at Example CSV file and the output.

You can put a variable to keep count while using Super CSV to find the number of lines. Only thing you have to do is to add the jar to your classpath and then access its methods

edited Nov 20 '14 at 08:39

Sufian

6,405
16
66
120

answered Nov 20 '14 at 07:39

Subhrajyoti Das

2,685
3
21
36

Built-in method to count number of lines in a CSV file?

3 Answers3