In relation to my question - List Map data in excel using java, is there a way where I can convert the code to read csv file with same output as a result
This is the sample csv data:
My expected Output would be like this:
Thank you!
Asked
Active
Viewed 225 times
0
-
4You can use OpenCSV library. – Arvind Kumar Avinash Dec 23 '20 at 09:47
-
1The expected output looks like the result of calling `toString()` on a collection containing the rows as parsed object of a class which implements a `toString()` itself – Jimmy R.T. Dec 23 '20 at 10:13
-
Post text rather than images, wherever possible, on this site. – Basil Bourque Dec 28 '20 at 01:15
1 Answers
0
No Map involved here, just a List.
You have not explained the semantics. But it appears that you simply need to define a Person class (or a Person record in modern Java) with five properties named in first row.
Read your CSV row by row, constructing a Person object for each row. I suggest using a library to help with the CSV parsing, such as Apache Commons CSV. Add each new Person object to a List such as ArrayList.
Call toString on your List to generate output text. If you want a different format, loop the Person objects in the list to generate your own text of desired format.
All of this has been covered many many times already on Stack Overflow. So search to learn more.
Basil Bourque
- 303,325
- 100
- 852
- 1,154