OpenCSV允许您使用@CsvBindAndJoinByName注解来做类似的事情。摘自文档：

public class Demonstration {

   @CsvBindByName(column = "index")
   private String index;

   @CsvBindAndJoinByName(column = ".*", elementType = String.class)
   private MultiValuedMap<String, String> theRest;

   // Getters and setters go here
}

同样的文档提到了一个警告：如果你有多个@CsvBindAndJoinByName，你必须小心不要有重叠的模式，否则结果是未定义的。

有同样的情况，想从CSV文件中访问未知列。

public class CSVFileDTO 
{
    @CsvBindByName
    private String name;

    @CsvBindAndJoinByName(column = ".*", elementType = String.class)
    private MultiValuedMap<String, String> theRest;
}

访问Rest列的方法

CSVReader csvReader = new CSVReader(Files.newBufferedReader(Paths.get("/tmp/data.csv")));
    List<CSVFileDTO> resultData = new CsvToBeanBuilder(csvReader)
            .withType(CSVFileDTO.class)
            .build()
            .parse();

    MultiValuedMap<String, String> multivaluedMap = resultData.get(0).getTheRest();
    for(Map.Entry<String, String> ent : multivaluedMap.entries())
    {
        System.out.println( ent.getKey() + " : " + ent.getValue() );
    }

检查https://github.com/ozlerhakan/poiji API的特性9以阅读excel文件。

public class MusicTrack {

@ExcelCellName("ID")
private String employeeId;

@ExcelCellName("AUTHOR")
private String author;

@ExcelCellName("NAME")
private String name;

@ExcelUnknownCells
private Map<String, String> unknownCells;}