supercsv读写CSV、TSV文件实例教程

    ICsvMapReader mapReader = null;
    try {
            mapReader = new CsvMapReader(new FileReader(CSV_FILENAME), CsvPreference.STANDARD_PREFERENCE);
           
            // the header columns are used as the keys to the Map
            final String[] header = mapReader.getHeader(true);
            final CellProcessor[] processors = getProcessors();
           
            Map<String, Object> customerMap;
            while( (customerMap = mapReader.read(header, processors)) != null ) {
                    System.out.println(String.format("lineNo=%s, rowNo=%s, customerMap=%s", mapReader.getLineNumber(),
                            mapReader.getRowNumber(), customerMap));
            }
           
    }
    finally {
            if( mapReader != null ) {
                    mapReader.close();
            }
    }}

/**
 * Sets up the processors used for the examples. There are 10 CSV columns, so 10 processors are defined. Empty
 * columns are read as null (hence the NotNull() for mandatory columns). * * @return the cell processors
 */
private static CellProcessor[] getProcessors() {

    final String emailRegex = "[a-z0-9._]+@[a-z0-9.]+"; // just an example, not very robust!
    StrRegEx.registerMessage(emailRegex, "must be a valid email address");
   
    final CellProcessor[] processors = new CellProcessor[] {
            new UniqueHashCode(), // customerNo (must be unique)
            new NotNull(), // firstName
            new NotNull(), // lastName
            new ParseDate("dd/MM/yyyy"), // birthDate
            new NotNull(), // mailingAddress
            new Optional(new ParseBool()), // married
            new Optional(new ParseInt()), // numberOfKids
            new NotNull(), // favouriteQuote
            new StrRegEx(emailRegex), // email
            new LMinMax(0L, LMinMax.MAX_LONG) // loyaltyPoints
    };
   
    return processors;}
</pre>

  /**
  * Ready to use configuration for Windows Excel exported CSV files.
  */
  public static final CsvPreference EXCEL_PREFERENCE = new CsvPreference.Builder('"' , ',' , "n").build();
 
  /**
  * Ready to use configuration for north European excel CSV files (columns are separated by ";" instead of ",")
  */
  public static final CsvPreference EXCEL_NORTH_EUROPE_PREFERENCE = new CsvPreference.Builder('"' , ';' , "n" ).build();
 
  /**
  * Ready to use configuration for tab -delimited files.
  */
  public static final CsvPreference TAB_PREFERENCE = new CsvPreference.Builder( '"', 't', "n").build();

</pre>