且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用Java从Excel(csv)文件中删除行?

更新时间:2023-12-03 21:13:40

JButton btnDeleteClient = new JButton("Delete Client");
    btnDeleteClient.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent arg0) {
            try {
                List<String[]> myEntries = new ArrayList<>();
                CSVReader reader = new CSVReader(new FileReader("Clients.csv"),',');
                myEntries = reader.readAll();
                List<String[]> toRemove = new ArrayList<>();
                for (String[] row: myEntries){
                    if(comboBox_1.getSelectedItem().equals(row[0]+" "+row[1])){
                        toRemove.add(row);
                    }
                }
                myEntries.removeAll(toRemove);
                CSVWriter writer = new CSVWriter(new FileWriter("Clients.csv"), ',',CSVWriter.NO_QUOTE_CHARACTER);
                for(String[]row : myEntries){        
                    writer.writeNext(row);
                }        
                writer.close();                    
            } catch (IOException ex) {
                ex.printStackTrace();
            }
        }
    });