WritableCell wc = ws.getWritableCell(0,0);
//判断单元格的类型,做出相应的转换
Label label = (Label)wc;
ws.getWritableCell(0,0);这句取出的应该是Number型的吧?
试试用Number作转换,Number nc = (Number)wc
遇到这样的情况可以先判断是哪种类型,再考虑怎么作转换,eg:
if(cell.getType()==CellType.NUMBER){
System.out.print(((NumberCell)cell).getValue());
}else if(cell.getType()==CellType.DATE){
System.out.print(((DateCell)cell).getDate());
}
excel读取错误java.lang.ClassCastException: jxl.write.Number cannot be cast to jxl.write.Label
最新推荐文章于 2023-02-02 10:11:16 发布