private void populateTblCustomer() {
   List<Customer> list = customers;
   DefaultTableModel tableModel = (DefaultTableModel) tblCustomer.getModel();
   tableModel.getDataVector().removeAllElements();
   // tblCustomer.repaint();
   if (list.size() > 0) {
     for (int i = 0; i < list.size(); i++) {
       Customer customer = list.get(i);
       tableModel.insertRow(
           i,
           new Object[] {
             i + 1,
             customer.getSurName(),
             customer.getForeName(),
             customer.getAddLine1(),
             customer.getPostCode(),
             customer.getTelNo(),
             customer.getEmail()
           });
     }
   } else {
     tableModel.insertRow(0, new Object[] {});
   }
 }
  public List<Customer> convertCSV(File file) {
    List<Customer> customers = new ArrayList<>();
    try {
      BufferedReader bf = null;
      bf = new BufferedReader(new FileReader(file));
      String line = null;
      while ((line = bf.readLine()) != null) {
        // FORENAME,SURNAME,CONTACTPERSON,ADDLINE1,ADDLINE2,CITY,EMAIL,FAX,MOBILE,POSTCODE,PROVINCE,TELNO
        try {
          String[] vals = line.split(",", -1);
          System.out.println("Name:" + vals[0] + " " + vals[1]);
          Customer customer = new Customer();
          customer.setForeName(vals[0]);
          customer.setSurName(vals[1]);
          customer.setContactPerson(vals[2]);
          customer.setAddLine1(vals[3]);
          customer.setAddLine2(vals[4]);
          customer.setCity(vals[5]);
          customer.setEmail(vals[6]);
          customer.setFax(vals[7]);
          customer.setMobile(vals[8]);
          customer.setPostCode(vals[9]);
          customer.setProvince(vals[10]);
          customer.setTelNo(vals[11]);
          customers.add(customer);
        } catch (Exception e) {

        }
      }
    } catch (FileNotFoundException ex) {
    } catch (IOException ex) {
    }

    return customers;
  }