java - 如何仅对行和固定数量的列进行 for 循环？

Question

我在 Android 中有一个从 excel 读取数据的应用程序。我想替换 while 循环并放置 for 循环。我只有 3 列，所以我认为还有另一种方法可以做到这一点。你能告诉我如何使用仅使用行和 3 列的 for 循环执行此 while 循环吗？

private void readExcelFile() {

        try{


            String inFileName = Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS)+"/"+"ola.xlsx";

            File file = new File(inFileName);
            Workbook workBook = WorkbookFactory.create(file);
            Sheet sheet  = workBook.getSheetAt(0);


            Iterator<Row> rowIter = sheet.rowIterator();
//this is the loop I talked about
            while(rowIter.hasNext()){


                Row myRow =rowIter.next();
                Iterator<Cell> cellIter = myRow.cellIterator();


                while(cellIter.hasNext()){
                    Cell myCell = cellIter.next();





                    Toast.makeText(getApplicationContext(), "cell Value: " + myCell.toString(), Toast.LENGTH_SHORT).show();
                }
            }
        }catch (Exception e){e.printStackTrace(); }

        return;
    }

Answer 1

好吧，如果你有行和列大小，你可以循环遍历单元格，而不是 android:

int totalCount = rowSize * columnSize;
Iterator<Cell> rowIter = sheet.rowIterator();
Iterator<Cell> cellIter;

for(int i = 0 ; i < totalCount ; i++){
    if(i % rowSize == 0){
        //Move to the Next Row
        myRow = rowIter.next();
        cellIter = myRow.cellIterator();
    }

    Cell myCell = cellIter.next();
}

虽然它可能有一两个错误，但我认为它会如您所愿地工作。