How to get the comma seperated values from the excel cell sheet using java code

Question

I am unable to get the comma separated values from the excel cell using java code.

I had tried using the following code also.

String [] items = commaSeparated.split("\\s*,\\s*");
List<String> container = Arrays.asList(items);

I want the output as a list like:

IND
PAK
USA
AUS

When the input is imported from the Excel cell as IND,PAK,USA,AUS.

The context of your question doesn't seem to make sense. We'll need more code, like statements for reading the Excel file and the contents of that Excel cell. — Max Voisard
– Max Voisard, Commented Aug 26, 2019 at 12:05

Thomas Martin · Accepted Answer · 2019-08-26 12:09:41Z

0

If all you want to do is print each item of your CSV data on a new line, this code will do the job.

    String csvLine = "IND,PAK,USA,AUS";
    Arrays.stream(csvLine.split(",")).forEach(
            item -> System.out.println(item)
    );

answered Aug 26, 2019 at 12:09

Thomas Martin

7689 silver badges20 bronze badges

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

1 Answer 1