Question

java写excel2007时 报Exception in thread "main" java.lang.ClassCastException:

Answer 1

导错包了啊，hssf和xssf，按照你写得，应该导入的是
org.apache.poi.hssf.usermodel.HSSFRichTextString

追问

import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
因为想支持03和07的
所以这几个都导入了
运行时就报:
org.apache.poi.hssf.usermodel.HSSFRichTextString cannot be cast to org.apache.poi.xssf.usermodel.XSSFRichTextString

追答

这是类型转换错误啊，包HSSFRich下的TextString 类不能被转换成XSSFRich包下的类TextString。你只导入包XSSFRich下的TextString 试试。debug调试一下，看看是在哪一行类型转换错误了啊。。

Answer 2

poi对应excel2007和excel2003有不同的读取方法，一个是hssf,另一个XSSF

Answer 3

类型不匹配。

Answer 4

，

追问

org.apache.poi.hssf.usermodel.HSSFRichTextString cannot be cast to org.apache.poi.xssf.usermodel.XSSFRichTextString

追答

vjdfnvjfndjvenfjjvejfvenshgghevherbfhebfherbfhejdnvjfdvjnsfvjnejovnejvnejvnfejnvufevjefnvjnefjvfenvjfenvjefnvidhcivdhivdifvdjfviefjvijefjviefjvienjjevjnefvineivneivniefnviefnviefvneiveivj女帝么infvejfnviefnviefveivneivbviucbufbgshbcdkbghkjgfygfsjhajakhshauajnjshbsjbsjhhsjnsjns兽聚鸟散jnjsbsjnjsnjsnjsnjsnjnnsjnsjnjsnsjnsjns啊gjsvwghhjjjnhjbvvshshwha纱布啊vhavg灰白色