excel读取错误

    xiaoxiao2022-06-29  45

    excel读取错误java.lang.ClassCastException: jxl.write.Number cannot be cast to jxl.write.Label

    或 jxl.read.biff.LabelSSTRecord cannot be cast to jxl.DateCell 2013年03月01日  ⁄ 综合 ⁄ 共 351字 ⁄ 字号  小 中 大  ⁄ 评论关闭 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()); } else if(cell.getType()==CellType.LABEl){ }
    转载请注明原文地址: https://ju.6miu.com/read-1124838.html

    最新回复(0)