Workbook wb =new HSSFWorkbook(fi);这样写有语法错误么?为什么编译出现错误,POI和IO包都引了Workbook wb =(Workbook)new HSSFWorkbook(fi);这样写的话运行时出现强制转化问题java.lang.ClassCastException: org.apache.poi.hssf.usermodel.HSSFWorkbook,那位高手指点一下啊?
调试欢乐多
/**
* 读取excel文件获得HSSFWorkbook对象
*/
public void open() throws IOException {
FileInputStream fis = new FileInputStream(file);
HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(fis));
fis.close();
}
poi2.0不支持这样的,但是poi3.6可以换到3.6就行了
//HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(fi)); HSSFWorkbook wb = new HSSFWorkbook(fi);
HSSFSheet sheet = wb.getSheetAt(0);
int rowNum = sheet.getLastRowNum()+1; //行
System.out.println("666666666666666666"+rowNum);
T_BCity city=new T_BCity();
for(int i=1;i<rowNum;i++){
HSSFRow row = sheet.getRow(i);
int cellNum = row.getLastCellNum(); //列
System.out.println("111111111111111"+cellNum);
for(short j=0;j<cellNum;j++){
HSSFCell cell = row.getCell(j); 现在已经把列里的值放入到cell里了,怎么样把cell放入到city对象里面啊