Would it be a good idea to add the following two methods to the cell interface so that the switch(cell.getCellType()) code can be taken care of in POI?
interface org.apache.poi.ss.usermodel.Cell {
Object getCellValue();
void setCellValue(Object value);
}
We would have to decide how to handle formulas, but otherwise the code is
straightforward. I think this would go a long way to making the POI API
easier to use.
Any objections?
