如何在Java Eclipse中读取excel CSV文件（逗号分隔值）？

Question

目标：创建一个面向对象的图形Java应用程序，该程序将：读取一个CSV（逗号分隔值）文件，该文件由学生姓名（名字、姓氏）、ID以及内容和交付的初始标记组成（未评估学生使用-1值）。

这是我的代码，但当我点击选择文件。。当它真的应该打开文件并读取数据时，它会显示“预期的名字、姓氏、ID、内容和交付”。但不知何故，它不起作用。在此处输入图像描述

下面是我的代码：

私有类ChooseFileListener实现ActionListener{

public void actionPerformed(ActionEvent event) {
  Section<Student> section;

  JFileChooser fileChooser = new JFileChooser();
  FileNameExtensionFilter filter = new FileNameExtensionFilter(
                                                               "CSV file", "csv");
  fileChooser.setFileFilter(filter);
  int returnValue = fileChooser.showOpenDialog(null);
  if (returnValue == JFileChooser.APPROVE_OPTION) {
    File selectedFile = fileChooser.getSelectedFile();
    if (selectedFile != null) {
      section = createNewSection(selectedFile);
      loadStudents(section, selectedFile);
      System.out.print(selectedFile);
}
}
}
}

public void RandomStudent(){
ArrayList<Student> students = new ArrayList<>();
max = (students.size()-1);
int x = (int) Math.random()* students.size();
System.out.println(x);
}


private Section<Student> createNewSection(File selectedFile) {
String filename = selectedFile.getName();
Section<Student> section = new Section<Student>(filename);
return section;
}


private void loadStudents(Section<Student> section, File selectedFile) {
Scanner in;
int MAX_COMMAS = 5;
try {
  in = new Scanner(selectedFile);
  String line = "";
  String[] studentData;
  in.nextLine();
  while (in.hasNext()) {
    line = in.nextLine();
    studentData = line.split(",");
    if (studentData.length == MAX_COMMAS) {
      section.addStudent(new Student(studentData[0],studentData[1],
                                     Integer.valueOf(studentData[2]), 
                                     Integer.valueOf(studentData[3]),
                                     Integer.valueOf(studentData[4])));
    } else {
      throw new Exception(
                          "Invalid file format. \nExcepted: firstname, lastname, id, content, delivery");
    }
  }
} catch (Exception e) {
  JOptionPane.showMessageDialog(null, e.getMessage());
}
}
}

我现在创建了另一个名为Section的类：

打包帕特尔。杰南；

导入java。util。ArrayList；

公共课组{

 private String data;
 private String FirstName;
 private String LastName;
 private int studentID;
 private int ContentMark;
 private int DeliveryMark;

 private ArrayList<Student> students = new ArrayList<>();

 public void FileData(String First, String Last, int ID, int Content, int Delivery){
      this.FirstName = First;
      this.LastName = Last;
      this.studentID = ID;
      this.ContentMark = Content;
      this.DeliveryMark = Delivery;
     }

public String setFirst(String First){
      return First;
}

 public String setLast (String Last){
     return Last;
 }
 public int setstudentID (int ID) {
     return ID;
 }
 public int setContentMark (int Content) {
     return Content;
 }
 public int setDeliveryMark (int Delivery) {
     return Delivery;
 }   

 public Section(String data) {
  this.data = data;
 }

 public void addStudent(Student student) {
  students.add(student);
 }

}

Answer 1

问题是您检查了MAX_COMMAS，但您正在根据字段的数量检查它。对于格式正确的文件，此值始终为5。因此，您确保到达代码的其他部分并始终抛出。

你想要表达的是：

if (studentData.length != MAX_COMMAS)