FileInputStream fileInputStream = new FileInputStream(xlsFilePath);
jxl.Workbook newWorkBook = Workbook.getWorkbook(fileInputStream);
Sheet newSheet = newWorkBook.getSheet(0);
Cell newCell = null;
String cellData = null;
int columnCode = 0;
if (objectName.equals("Speed")){
for (int i = 0; i < 150; i++){
newCell = newSheet.getCell(0, i);
cellData = newCell.getContents();
if (cellData.equals("Speed")) {
newCell = newSheet.getCell(0, i + 2);
return newCell.getContents();
}
}
}
其中newSheet.getCell(0, i)用一个变量可以,如果用两个变量newSheet.getCell(j, i),在第一行第一列为空时,直接退出,为什么,我只是用两个变量去循环行和列,请高手指教!!!!
jxl.Workbook newWorkBook = Workbook.getWorkbook(fileInputStream);
Sheet newSheet = newWorkBook.getSheet(0);
Cell newCell = null;
String cellData = null;
int columnCode = 0;
if (objectName.equals("Speed")){
for (int i = 0; i < 150; i++){
newCell = newSheet.getCell(0, i);
cellData = newCell.getContents();
if (cellData.equals("Speed")) {
newCell = newSheet.getCell(0, i + 2);
return newCell.getContents();
}
}
}
其中newSheet.getCell(0, i)用一个变量可以,如果用两个变量newSheet.getCell(j, i),在第一行第一列为空时,直接退出,为什么,我只是用两个变量去循环行和列,请高手指教!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货